Start your search for smaller waves at the south end of any beach (except Bondi). Look for somewhere out of the wind. Remember that overcast and cold weather generally keeps the crowds away.
Heavy rain can be a health problem.
For places you may not have thought about see the Sydney Beach Map: maps.google.com/maps
Video of Neilsen Park inside the harbour breaking in April 2009.