The Sydney Central Business District and Darling Harbour are definitely the most popular and best areas to stay in Sydney for tourists. I recommend staying in either of those two neighbourhoods when visiting the city and looking for where to stay in Sydney for the first time.