OP, thanks for this thread, and thanks to all for this discussion. To hit my opinion on the OP:
Future vacation planning - which public aquariums have lots of reef corals and home aquarium size fish on display? Most seem to favor penguins, seals, stingrays, dolphins and similar large animals.
As you mentioned, public aquaria make their family trip $$ off of (i.e. the kiddos want to see most) the penguins, seals, touch pools, dolphins and big pelagic tanks. heck, even
amazon biotopes get better coverage, since many have small-to-large
amazon bird and fish exhibits, with the obligatory arapaima. The disappointment many people feel at the Waikiki aquarium (no such exhibits, only a few reef tanks) is an example of why a heavy reef focus might be financially dangerous. (that said, while I appreciate all the work they demonstrated in their backstage tour, I do think they are coasting off of their pioneering work decades ago and need a massive remodel and recapitalization)
Coral exhibits are generally small afterthoughts and part of the smaller exhibits. That said, there are several places I've been to with nice small reef exhibits. San Diego, Monterey, Noboribetsu in Hokkaido Japan have nice reef side exhibits. One of my favorite reef tanks period is the gorgonian tank at the Henry Dooley Zoo at Omaha.
An alternative is the Berlin Zoo, which - not surprising from the land of Heiko Bleher, the center of Europe's wonky freshwater biotope craze, and really wonky brands like eheim, , tunze, tropic-marin, ATI, trident, korallen zucht - is like 30+ different fresh and salt water biotopes. (as well a a large central portion with like alligators and the like, but no seal, dophins, penguins etc.). This is my vote for the best public aquarium from a hobbyist/enthusiast perspective, even though some tanks were inevitably (in a 30+ tank institution) a bit underwhelming for their concept and should be reset.