I will add to this post.
Originally posted by JinDesu Shoot darker. Expose for those lights. Then in post process, bring up the shadows and blacks to match as much as possible. ....
The first picture is not bad. The light on the water is a little hot and so exposure could be less. However, the lights themselves will always be overexposed, of course. So, reduce exposure to retain detail in the light reflected in water and forget the rest.
Another thing to try is taking pictures in evening... twilight, really.
Contrast is less then. Lights will be on. Cloudy evenings are better. So may have some nice clouds as well. I find that even when I can still see easily, it is possible to later make the images look as 'night' as I want... I just have less contrast when I take the picture... Looks like your pictures were mot taken at darkest night..
For your first picture, if you correct WB some for the light on the buildings, the sky will be dark blue. Not a natural blue, but interesting, perhaps. The amount of blue depends on the amount of correction for the street lights. This is because the clouds are shady daylight and the streets are incandescent or mercury vapor. The two will never match unless you use an adjustment layer to set WB for sky/water and WB for street light.
Oh, in case 'overwhelming' includes the color, do play with WB to adjust that whether the picture was taken at evening or night. Sometimes, a good night picture will need some work on layers or local adjustment in PP...