I’m not aware of any current Smart Cameras that use SMS natively as a means to deliver a notification.
However, you can easily create a rule via IFTTT that will send you an SMS message if whatever condition you specify is met. Example: If motion is detected on Camera, send text to (XXX) XXX-XXXX. I believe IFTTT only allows for 100 SMS messages a month, but it may be worth checking into.