There is a modicum of a chance (that's .067% to the IRS agent) that you will become famous by bringing down some money-hungry big dog of the business world by spearheading an audit that reveals seriously fraudulent claims. People will recognize your work, but never your face.
The truth is that IRS auditing is inherently behind-the-scenes work. You will spend the majority of your days surrounded by your office walls and stacks and stacks of numbers. If you do need to go out to investigate a claim, you will be immediately directed to that back room where businesses store boxes of last year's expense reports next to the office Christmas decorations.