We spent 1 night at the Hilton Auckland in November 2010. As a Diamond member, we did not get an upgraded room with a harbor view. We only got a room on the top floor looking into a residential building. However, the room itself was roomy and clean. The bathroom had a tub and shower and was very functional. The bed was comfortable and afforded a great night's sleep.
In room internet is complimentary for Diamond members and it was fast.
Breakfast is also complimentary for Diamond members and we had the buffet and a la carte ordered items available to us. We ordered some a la carte items. The food was average.
As for location, the hotel is in a great location. Once you walk from the end of the pier where Hilton sits, there are a lot of restaurants available to you. Sky City is about a 10-15 minute walk.
We also took a ferry to Waiheke Island for half a day and the pier is next to the Hilton and very convenient.
I would definitely recommend this hotel for the location and the rooms.More