Lots of choices on Vancouver Island ... and Ogden Point would be way down the list for me.
Browning Pass (aka Pt. Hardy) would be my first choice ... because the diving there is awesome. But it's not wrecks. Besides God's Pocket, the Browning Pass Hideaway is very close to the dive sites. It's undergone some recent renovations and is a much nicer place to stay than it was a couple years ago.
Nanaimo is a great choice if wrecks are what you want ... they have the most, and they're convenient. The Buccaneer is a very diver-friendly motel right close to where the boats go out, and there's some pretty good places to eat within walking distance.
Quadra Island/Campbell River would be high on the list of places to go ... great wall diving, and one artificial reef/wreck within close proximity. I'm not nutz about the available dive charters, that that's more a personal call than anything. The diving's incredible.
Barkley Sound ... Rendezvous Lodge ... fantastic pinnacle dives, some really nice reefs, very isolated, and if you can make it out to the Vanlene, a fantastic wreck that is a real wreck rather than an artificial one.
Nootka Sound ... Tatsha Dive Charters ... one of my favorite VanIsle dive destinations ... great diving and affordable lodging in a small, isolated village. Your time frame might not work out well, in that you'll be competing with a LOT of fishermen for town resources, and probably for space on the best dive sites.
Over on the mainland, Sechelt Inlet ... Porpoise Bay Dive Charters ... fantastic dive op, great diving known for some of the best vis in the Pacific Northwest, and the Chaudierre ... another artificial reef/wreck.
You can't go wrong with any of those choices. I'd recommend researching what each has to offer, check for availability (July/August is a popular time, so some are probably already booked) and make your reservations ... sooner is better than later ...
... Bob (Grateful Diver)