You can get a wonderful view of Circular Quay and the harbour from the South East Pylon lookout on the harbour bridge. Entry fees are reasonable and there are no restrictions on photography or how long you stay up there. Entry time is between 10 am - 5 pm so the best light would be late in the day around mid-winter.
Sydney Opera House, Circular Quay and The Rocks from Sydney Harbour Bridge