There is not a camera made that will perform as well as the human eye/brain.
Get a camera app for your phone that will allow you to change the shutter speed and iso manually ( I use procam 6 but i have several that are made for low light night shots as well ) and use a tripod.
Also research HDR photography, this is when you take several shots of the same scene at different exposures and then combine them all together in post production. This allows you to get the proper exposure for the shadows in some shots and the highlights in other shots. After you combine them in post then you have a better representation of the dynamic range of the scene you are photographing then would be possible with just a one a shot exposure.
Night photography is difficult, the dynamic range is far to wide for a camera to capture all the detail that your eye/brain see's . Your brain is very good at it.
Take a class on photography it will benefit you to have a solid understanding of light and how cameras see it ( even if you are only using a phone camera. )