The totem lodge motel is an older hotel but has kitchenettes. Eagle bluff bnb right at the dock in cow bay has a shared kitchen and I’d say is one of the best places to stay if you can get in, it’s usually booked long in advance. There’s moorage at the yacht club, city owned cow bay dock, and the three docks run by port Ed harbour authority, Rushbrook, Fairview, and cow bay. Call ahead for the yacht club or the one owned by the city.
You don’t need to make the 35 mile run to Dundas and the bugs, but it can be good. As can pretty much anywhere in the area. Late June isn’t what it used to be though, and though it can be prime time Chinook fishing, it can come with some lulls. A week of fishing should give you time to find a few spots and dial in on tides. Late June there’s still good fishing right at that bell boy you’re talking about, and all the other places listed above.