I have dived Cape Breton and Saskatchewan off Snake Island (Nanaimo) and Columbia.
The wrecks were noteworthy for the diversity and quantity of marine life that has made them their home. Not only does the life proliferate on the old hulls but also in the areas in proximity as the biomass increases.
My first dive on Saskatchewan brought me face to face with two wolf eels. The numbers of anemone (especially plumose), variety of sea stars, urchins etc. made great fodder for the rockfish, cabazon, lingcod, greenlings etc. that hung around the wrecks. These smaller fish attracted larger predators like dog fish, seals and sea lions.
While the seabed in the areas where I dove (particularly around Quadra Island) were lush and colourful, I found that the amount of life in proximity to the wrecks was greater.
In addition to the benefit of creating marine habitat, the wrecks were also attractive to me as a tourist. I spent two weeks on Vancouver Island, spending money on accommodation, food, travel etc.
I wouldn't expect you to see me on the wrecks as they are sitting in 80' - 110' of water.