The simple and short answer is yes!
However this is a well-cruised area and you will have to be somewhat creative to find the small corners of paradise that aren't already full of boaters.
Sacketts Harbor is a prime example of this... though nice with interesting restaurants and real-estate it is very overcrowded IMO. However there are very nice anchorages within easy distance that fit your description.
Main Duck island, Prince Edward bay, Waupoos, Amherst island (day use), Cape Vincent dock etc... should fill your expectations. I would stay away from the Clayton to Alex Bay corridor because of the freighters, poker runs and sundry other noisemakers and partymakers!
You should consider goign past that first lock: the drop varies between six inches and a foot'n a half... power boaters use one of the sluice gates to avoid the lock! There are great gunkholes between Iroquois and Snell locks! Also there are a lot less boaters!
The next and foremost question is which way will you use to come to this region: up the Hudson to Waterford, then the barge and Osweego canals to Lake Ontario? Up the Hudson Waterford, the Champlain canal to the Richelieu and up the Richelieu to Sorel, up the St-Lawrence to Lake Ontario? North East from Mass. to Brooklyne NS, Halifax, Canso, the Maggies (Magdalen Islands), Percé, Gaspé, the Bic, up & down the Saguenay Fjord (have a look at the blue whales and all those belugas), Québec City, Montréal, Lake Ontario?? Talk about gunkholing beauty that is it... and believe me you will see others only if you look for them!
Rationally the St-Lawrence route is easier going down (NE) than coming up (SW). Because of wind & current which are mostly from the SW.