Finally a thread where I don't feel overwhelmed by everyone else's posts ha ha.
Shedd in Chicago. My "very first" when I was about 7 years old.
Sydney Australia-- has an awesome shallow reef display with great top down views, mood music, and the best sign ever near the alligators ("Don't lean over the rail, if the fall doesn't kill you, the alligators will.") This is one I would definitely visit again (oh wait, I did go back ha ha).
Hong Kong "Adventureland" which turned to be an amusement park built on the side of a mountain WITH a pretty decent sized (though very dark) aquarium. Only about $25 US equivalent, and includes access to the full amusement park.
Coney Island -- nice aquarium, but the surrounding area was not too cool (not to mention the LOOOONG subway ride).
Monterey Bay, CA -- aka Kiddie central. Do NOT visit during the Summer or on school breaks unless you are a parent and used to swarms of kids.
Academy of Sciences, SF. GREAT shallow clam tank. This area was also not crowded and the longer I stood there the more clams I saw. Really cool.
Omaha Henry Doorly Zoo. Love the tunnel.
Pier 39 in SF -- at best (at least to me) a mild diversion.
Las Vegas -- Bellagio. To me, these tanks didn't look well maintained. Think lots of fish with tattered fins and algae growth run amok.
Long Beach, CA. A couple of cool displays near the front.