Originally posted by slr_neophyte these bright lights at the foreground of my image, are still extremely overexposed, or burned out, or causing flare (maybe due to my UV filter - which I probably should have removed in some cases).
Mount a good, tight lens hood, particularly with wide angle photos, but for telephoto as well. Replace UV filter with a multicoated polarizing filter, or no filter at all.
In LR, you can add a gradient and then lower the contrast and brightness of just the bottom part of the image. Or you can use a brush and paint only the lightbulbs that you want, and decrease their contrast, brightness, exposure, and add saturation.
Originally posted by Murfy I actually don't think you could get much better with that sun exposure, that seems pretty defined to me.
Yep. There is only so much you can do. Street lights, sun, moon, will often (ie, just about always) look overexposed. Only thing you can do about this is exposure bracketing and then HDR, but this can make things look very, very unnatural. The sun being blown out is kind of something you should expect. I mean, you can't even look at it with the naked eye. How would a lit lightbulb look when it is darkened? The city would look like a dystopian painting
I think the sample photos attached in the OP are not bad at all.