Precisely because the clear bottle stuff is - as you observe so correctly - "trash", I never drink Corona.
Are you telling me that there is a palatable version in existence?
Yes. Fairly heavy brown bottle. It's about 960 ml and I've only seen them in two stores off and on. I'd be surprised if they're exported anywhere else in North America or Europe for that matter. It's hard to describe what it tastes like, but it's what you would expect Corona to be like without the foul odor and taste because of UV degradation. It finishes crisp and nice, with just a minute hint of sweetness. It's what Extra should taste like, albeit it would still be a bit better. Once the beer degrades in the clear bottles, then all is lost. I think the worst offender of skunked/fouled beer is Newcastle Ale. Get it on draft if you must drink it.
Mexican beers aren't the best, but of the Modelo group the only mass produced onces I recommend are a brand called Pacifico and Modelo Negra. The latter of which has a malty sweet finish. If I had to compare the aftertaste, it's similar to a decent kwass. Bohemia, by another producer, is another good Mexican beer, however, I recommend the Oscura variety over others.