Fantastic place to stay. I thoroughly recommend it for the view alone!
As some of the others have mentioned, there is a hill to climb when walking in/out of Queenstown. But it is worth it for the view!