My wife considers this to be cheating!
A photograph taken on a bright, sunny day darkened
down using Photoshop Elements and Photomatix and finished
off with a 'lighting effect' from PhotoImpact.
A lot less hassle than visiting Queensferry at night!