I prefer whatever type of water the individual fish I am interested in comes from for that particular aquarium. There are plenty of interesting fish from fresh, brackish, saltwater, coldwater, tropical, temperate, whatever waters to keep any reasonable person occupied for a lifetime.
To assume that the only "interesting" fish are those which are commercial sold en masse, or those which are discussed on this website at large, is a foolish notion. Ignorance of other options does not eliminate their viability.
I would also venture that the "average joe" is more interested in big, mean predators than small colorful clownfish. Just look at the prevalence of monster tanks, catfish, piranhas, pacus, oscars, gar, lionfish, groupers, sharks, snakeheads, etc. Those fish aren't flashy in the slightest, compared to most of the "wimpy" offerings in the trade, yet the obsession still remains.
If you want to waste time insisting that one environment is superior to the other and beating that horse to death, be my guest. I'll be too busy enjoy my fish