The most amazing sight for me on our Canadian cruise in 2012 was when we were pulling back into NYC the morning of debarkation, we were up before dawn and we saw from our balcony the amazing view, I was still in my PJ's, I threw on a blanket and we ran up to deck 10.
OMG, the view of the city all lit up was just breathtaking.
I wanted to crawl in a hole when I saw all the people out there with the same idea and I was out in Pj's and a blanket.
If you do this cruise, try to get up there and see it, its just amazing.