I've been to:
Cabrillo Marine Aquarium - I would classify it as a small aquarium, sort of the educational type, rather than the bigger flashy type, if that makes any sense.
Oregon Coast Aquarium - I really like this one, it's worth a trip. I was there while they were building the exhibit for Keiko, so it's been awhile. I wish they had kept him, I think his quality of life was better there than in the wild. Considering he got so bored he swam all the way from Iceland to Norway, as I recall. Anyway, my favorite part of the aquarium is the walk-through puffin aviary.
Great Lakes Aquarium - this one's nice, too. Bigger than I would have expected from a relatively small city such as Duluth.
Jenkinson's Aquarium - I would say this is pretty much what you would expect, a small aquarium on an ocean boardwalk on the Jersey Shore. It reminds me of several of the small aquariums I've visited in the UK. I notice they were AZA accredited last year.
I actually haven't gotten to the new aquarium at Wildlife World Zoo yet. Trying to talk my mom into going, too. They've never reciprocated with AZA members when I've gone in the past, probably hasn't changed. We tried to do a staff swap with them when I was still a night camp instructor at the Phx Zoo, but they weren't interested - you know the thing, we'll go to yours and you come to ours so we all learn new stuff. San Diego did it, although I wasn't able to go.
I know a bit about the history (I'm a Phoenix native). When I was a kid, the owner, Mickey Olson, had an exotic bird farm not far from where I lived. When my parents first bought their house, it was really in the boondocks, but now, completely developed for miles and miles. So, I think gradually Mickey wanted more space, and a less urban environment, so he bought a big plot of land in what is still a fairly remote spot (although probably not in 10 years!), and bred more and more exotics. At some point he opened it to the public as a zoo. I think this is why you still see so much non-state of the art exhibit design. They were originally just designed for breeding, and not viewing.