I have.
You didn’t mention if it was indoor / outdoor
I tried 3 different types of cameras.
The first one was cheap, SMS but a piece of shit, so lets not even discuss it.
The second was an indoor only, ok camera, ok set up, it was reliable, but was over priced for what you got
The third is the path I think you should pursue. I have used a few and can give you brands if required, but shopping locally is probably your best bet.
Trail cameras should meet your requirements. The market is flooded with them, the majority are standalone, but there are still a good number of SMS capable models.
The Only downside is the range of view are almost always wide and short, so if you want to look further away, it may not do what you want, but if you want to cover a wider area, over a shorter distance, then they should meet all your criteria.
They can generally send SMS and/or email notifications, those will generally have a thumbnail attached. From there you can pull down a full sized image.
I have used a few, and they keep getting better.
The last one I bought was about 4 years ago, so thats as upto date as my information is, but I got a couple of Owlzers as a starting point for you.
There is an accompanying app to go with it, and set up is easy.
https://www.owlzer.com/
I got the Z1 4G trail cameras
When you start looking, the obvious difference will be the price difference. 3G/4g cameras will be more expensive than the standalone equivalents.
Like I say, my knowledge is outdated, but if you have more questions, fire away
good luck