VS BLUE is still the greatest battle in the series, in my opinion. facing your rival as champion is just hard to live up to.
I like the Red battle more because it's more of a "face yourself" kind of battle. It'll never be replicated in that sense due to how big Pokemon was at the time, and how iconic it was.
I'd say the Gary battle is my second favorite.