There is some great fine shore diving in Bermuda, but one needs a
local diver with knowledge and a car to carry tanks, weights, and
other gear.

One shouldn't be surprised to discover that Civil War wrecks, now
almost 150 years old, aren't in such great shape!  There are older
(wooden) wrecks there which are even more deteriorated.  The amazing
thing would be if they weren't!

The 20th century wrecks found their fate on the reefs and having to
rest in shallow water open to the Atlantic, have been smashed by
storms for decades.  I've enjoyed trying to reconstruct in my mind how
these ships came to their ends, keeping my eyes open for artifacts
(although one can't take them), swimming through and under some of the
wreckage, and admiring the massive engines, boilers, and winches.  If
it's intact wrecks you fancy, there are two small vessels deliberately
sunk.

As for visibility, it's not dependable.  However, it was in Bermuda
that I experienced the best visibility I've ever had in about 1000
dives (most in tropical waters) - about 200 feet.  As soon as I jumped
in, I knew it was special.  We had a good measure because the boat
(about a 45 footer) had put out a 150 foot trailer line with a big
float on the end off the stern and we could (barely) see the float
from beneath the bow.