Answer:
While champagne is not typically thought of as an aperitif wine, it is, in fact, used as an aperitif and is thus likely the most "famous" aperitif.
That aside, in the realm of what are most commonly thought of as aperitif wines, I would think that Lillet White and Dubonnet Red are probably the two most famous - and most popular - wine aperitifs. They are indeed delicious!