Welcome,
As you have seen, MP isn't everything. You need to chase sensor size, not MP. Many 4MP, 5MP, and 8MP cams are on a 1/2.8" or 1/3" sensor which is great for 2MP, but you need way more light for more MP on that size sensor.
You need to identify the areas you want to cover and pick a...