Better local integration would also be useful. (Axis cameras have supported writing (and recycling) video on a local SMB share for a very long time, with nothing special required on the back end -- but they're not consumer products).
Improved image quality would also be useful. There always seems to be a certain softness and definite lack of fluidity in consumer cameras that has been solved in things like cheap smartphones and GoPros for a over a decade.
Tight integration with local home automation systems like Home Assistant would be great, so I can observe and control all of the things from a central point using my pocket supercomputer.
But otherwise: If all one wants from a camera is for it to take OK-ish pictures and send them down the pipe, then that's a reasonably-solved problem.