A lot of flagship phones have good cameras, and so do some mid range devices, however you can't always rely on Auto mode. Getting the best out of a camera requires having knowledge about photography and how cameras work. Point being, you need to know your way around the Manual or Pro mode on the camera app, to tinker with some things and get the best photo.
The Note 5 does indeed have a great camera, try the S7 edge, or the Huwaei Mate series, as long as you have manual controls, you should be able to get a great photo.
Even the OnePlus 3/3T has a great camera, people are happy with it as a point and shoot camera and when fiddling with camera controls as well, though you may have to use an app for that as I'm not sure if the built-in one supports manual control over the camera.
Sent from my SM-G935F