If you're trying to become famous as a waiter, then we're pretty confident you're either an actor or musician, or you're completely confused about what a waiter is. You won't become famous for doing your job—in fact, most people you meet will probably forget your name the minute you walk away from the table—but you may find that you become popular within your restaurant.
Quite often, with good establishments that have repeat guests, you may find that you have requests for you to work the table. Patrons who you've hit it off with for whatever reason—maybe they like your attitude, maybe they just like the cut of your jib—will specifically ask to be seated in your section. Good for you; this typically means better tips and probably an easy table to work with.