I am looking to get a new camera as my Olympus Tough TG-610 has had it after two years of use. It survived what I put it through but I missed my Sony dsc-s780. The Sony had more vibrant colors and I thought had better picture quality. Also, I take a lot of photos of snakes at night and the Olympus always had a major issues with shadows while the Sony performed remarkably well.

So, what do I look for in a camera for night photography?

Is there a camera out there that would give me the resolution, macro, durability, and night photographs that would suit me.

Not looking to spend more than $500.

Half tempted to just buy another Sony but I am under the suspicion I can get one that suits my needs better than my last one.

Any help would be much appreciated.