I make comparison between my old Digicam Sony DSC-W130, Nexus 5, and Nexus 5 HDR+ Mode :)
First thing to note: HDR+ is definitely much better than auto mode, always use it when possible!
Overall, I'm satisfied with the Nexus 5 camera, but it didn't beat the Sony. Nexus 5 outperformed the Sony...