OK, I'm going to look for the nearest bridge.I hear ya, the last thing you want is buyers remorse LOL. Like I did chasing MP and buying the 49425 first and then going and buying the 49225 within a few months LOL.
Sometimes we need to learn the hard way LOL. We can tell you not chase MP and blah blah blah, but sometimes we have to experience it ourselves.
If it were me I would look at putting together the list of cameras on the proper MP/sensor ratio or better (like in that case of the 2MP on the 1/1.8" sensor) and then from that pick the one that will give you the best range of motion for what you are trying to accomplish.
It's just that I also think that the 2 Mpx camera without the IR illumination at night will be a complete mess of pixelated image.
At the moment the only thing I can fall back on is the experience I've had with the Reolink cameras (a complete disaster) and the camera I currently have, the Hikvision DS-2CD2087G2-L which, day or night, the images are very good, and its hardware configuration is very similar to the SD8C845FG-HNF.