Can't speak for Vancouver except real estate is through the roof there right now with almost zero vacancy rate for rentals and a teardown house on a tiny city lot starts in 7 figures. I would expect liveaboard marinas
to be in very high demand.
Here on Vancouver Island things are a little more civilized and unless you absolutely need to be in Vancouver, may I suggest Victoria has a lot to offer. James Bay is a lovely community where I live and Fisherman's Wharf is a couple minutes walk from downtown and reasonable liveaboard
moorage. Not sure how big the waiting list is. Cowichan Bay about 45min north of Victoria is where my boat lives and has reasonable moorage.