Hi fellow HA user in the wild.
Whatever cams you go with, most important thing is that they support a direct rtsp connection. Frigate is an excellent add-on for recording, and for object detection if you want to do that.
We have some generic IP cameras here that have local access only, and a couple of Arduino camera PCBs in printed housings.
A coral TPU is essential if you want to get into object detection on more than one camera. Can use the CPU for testing, but it's very easy to tap it out.