If you are in the Vancouver area, also use the Deep Cove Yacht club reciprocals, I bet you have them. I lived in Deep Cover before moving over to Vancouver Island and sadly it has become a very trendy place. People don't know what to do, so they go to Trip Advisor for some suggestions and Deep Cove pops up.
But its still a neat place to go. You just have to pay attention to the currents under the First Narrows Bridge (Also called "The Iron Workers Memorial Bridge" something like 17 died when building it) a little bit more seriously than the currents under the Lions Gate bridge, but people come and go all the time. If you were a sailboat, you can request to have the train bridge raised, which is beside the Second Narrows bridge.
You will be cruising into an area called Indian Arm and is the most southerly fjord in North America. I like to call it "The Poor Man's Desolation Sound." Poor man's because it is closer to Vancouverites (thus less fuel) and like Desolation because it is a fjord like the Sound.
And if you go, buy a donut (doesn't look like a donut) at "Honey's," they are famous. Honey's is about a 40 yard walk from the public pier and just a snort more from the Deep Cove Yacht Club.
If you don't have a reciprocal, you can anchor up to two weeks and the bottom is good. My one local tip, when you come in mostly everyone uses the anchoring area to the left as your returning to the Cove. Instead anchor on the right, there will only be a couple of boats there. The ride from your dinghy to the public pier will be all of one minute.
PS: mostly locals go to Deep Cove as people like yourself (Americans) want to moor at a marina in the downtown area so they can shop and stuff. The locals don't need that experience so instead they go to an area that is in the city but feels more like Desolation Sound.
Live View of Deep Cove: [Oh and another reason to anchor on the right side of the Cove as you enter it is this. Do you see those boats at anchor on the left side - but in the live cam, on the right - well in the summer there will be hoards in Kayaks, some very experienced, others first time out paddling in and around them. The Camera is actually located on Deep Cove Canoe and Kayak center]
https://www.deepcovekayak.com/live-cove-cam/
