I would recommend the Shangri-la Hotel (high floor obviously!)and echo Esselle’s recommendation of Cafe Sydney (new years eve or not!) – but it will be very expensive!
When I was planning our trip to Sydney, someone suggested serviced apartments on the other side of the city – looking over to the Opera House and the Bridge – that may be worth looking into as well. Sorry cant remember the names but someone will chip in.