I was in Five Dock Bay North for over a year. Fantastic spot: easy to get to, free unlimited parking, dinghy storage on grass / beach. Little fetch so often still except that the nice boat ramp is used quite a bit on weekends so a few motorboat waves but mostly from light recreational fishing boats. You want to be as close to the dinghy storage as possible; less rowing, further from channel out of bay. North Western spots seemed to be impacted by fast ferry waves a little.
View of sunset to the West if you're sleeping. Pelicans (thus our boat name). Also Whitworths is 5 mins away.
I did hear that some yacht owners had accessed the end of the floating pontoon at the ramp on a good high tide - I was never game to try but def worth checking out (even if it was only on a king tide it could be useful).
I kind of miss it - but I don't miss motoring all the way to a decent breeze or tacking down river.
I think Drummoyne or Balmain would be good if you can get in a protected spot - closer to the Harbour - but the waiting list back then was a while and I wanted to move further east.