All swings and roundabouts. Using compact camera, bridge camera or DSLR with a zoom lens and the results "in the field" are all about the same. The bridge camera is easiest to use and overall gives best value for money results, Not very good for landscapes though in poor light.
Lovely photo. Were you there about 9.45 pm right in front of the demarcation rope by three man hole covers by any chance?
Also, what camera settings did you use?
I went there at the time stated and it took a while before I got my settings sorted out. I can't look at my efforts until the weekend, but when I do, I'll put one on here if it's any good.