There's actually a lot less life in the ocean - it's a virtual desert compared to fresh water - at least in the first 30 ft or so of fresh water where there is enough light. But what's in the ocean is prettier.
It's also less consistent.
For example, My best ocean dive ever was on the Carribesea (a WWII wreck off NC) on a day with epic viz (150' or so), lots of sand tiger sharks, lots of mid size fish and an enormous bait ball maybe 75 feet across that kept engulfing the sharks, I suspect to get some protection from the ring of mid sized fish (barracuda, tuna, etc) that were trying to eat them. So the ball would swarm over me and then a shark would swim by maybe a foot and a half away - the limit of the viz in the bait ball, then the ball would drift and away and come swirling back. As an added bonus the ride out and back was on mill pond calm seas.
The very next dive weekend consisted of rolling in the swells and 6' waves while half the boat, me included, threw up all the way out and back. The dive itself had 10' of viz in very brown water that makes fresh water look appealing on a wreck that was devoid of life. The second dive was cancelled as the seas had increased and it was beyond time to go home.
Yet it's often kinda the same. I've seen reefs and wrecks off bermuda that look a lot like reefs off the Dry Tortugas and a wreck anywhere pretty much looks like wreck anywhere else whether it's off Bermuda, off Key West, in the gulf of mexico or off the coast of Delaware.
Along the east coast the major difference is whether you are in the gulf stream (usually great viz and warm, cerulean blue water, or the labrador current - cold water, 20-30' viz and mostly green looking, and both are distinctly different types of diving.
I've never lost the appeal of fresh water, and in particular I really like diving in springs and in caves - nothing really beats that for visibility or beauty and you seldom get blown out by weather and you never get sea sick on the boat ride to the dive site.