Devonport Wharf and village has some spec views over the harbour and Auckland City as you'd expect given it's next door to the Navy base.HMNZS Philomel has pretty sweet views bro, but not open to the public AFAIK.
We use to live in Birkenhead and Northcote Point jetty had great views to the city from under the bridge. Walking to the Birkenhead shops, we had views of the upper harbour and city which is picturesque in itself. Miss that.