I'm not a big race fan either, but being a native Hoosier, I also get a bit melancholy when I think about the "glory days" of Indy 500 racing, when names like Unser, Foyt, Mears, and Andretti ruled the track.
Our family actually has a history with the Indy 500 and the Hulman-George family, who owns the racetrack. My DH's grandfather, a native of Terre Haute, used to work for Tony Hulman, and collected many of the vintage race cars that are now on display at the Indy 500 Museum.
I think the beginning of the decline was the split between the CART league and the IRL, which couldn't have come at a worse time, as it coincided with the phenomenal rise of NASCAR. Now that Tony George is also a car owner, perhaps he'll be more responsive to the drivers and other owners and build the Indy 500 back up to it's previous prestige. And having some "celebrities" like Danica Patrick, David Letterman, and Dario Franchitti (married to movie star Ashley Judd) can't hurt.
Oh, and in answer to your question, Galahad, I like Kenny Brack, Tony Kanaan, and Dario Franchitti.