There are a few Topics on this forum that talk about the pro’s and con’s of different cameras.
If you’re looking for integration with SmartThings to get a push notification when there is movement then it’s either Arlo or Foscam (custom integration). You can also use Blink, which are awesome cameras that run on 2 batteries for upto 2 years. Both Foscam and Blink have cloud recordings. Blink is awesome when you want wireless cameras and a simple PIR motion sensor, Foscam really shines when you need night vision, custom motion detection zones, 270 degree Panning and Tilting. Both can be viewed live streaming using their native apps. Foscam may live stream through ST depending on your phone. Blink has an IFTTT integration available for SmartThings which allows you get (delayed) notifications about motion.