As someone else said - often poor vis = lots of nutrients in the water = lots to see. Yes you have to get close but so what.
Cold, I agree. I gave up diving here PNW for many years in large part because putting on two layers of skin tight 3/8ths neoprene was just way to much work and at any significant depth it was like wearing a t-shirt in a blizzard. Now I have a dry suit and the cold is no big deal. More trouble to gear up than tropical diving, but the life around here is well worth the trouble. As much or more to see than most tropical diving I have done.
Do a search for Browning Wall, Dodds Narrows, Race Rocks or Quadra Island - cold water diving at its best. Life so thick that you can't see the rock it is attached to.