If you want to look around Sydney a bit then a hotel near the Cruise Terminal may be best, or at least in the CBD. The Rendezvous is close and normally moderately priced.
If you wantva airport hotel, then the Rydges at International airport is best located although anything near Mascot will have both public transport and a airport shuttle.