To be fair, Indy is not like normal ovals. Even the drivers say it drives like a road course that only has four turns, and in most recent years it's been a real thriller. And besides that, the race is only part of the reason for going,
it is an event and a spectacle that is a real experience to be part of. You don't have to bake in the grandstand either, most of the outer frontstretch grandstand has a roof on it. My current seats are under the roof just behind the start/finish line, last year tied the hottest 500 on record and I was just fine in my shady seat.
If you're a motorsports fan you owe it to yourself to take the race in at least once, it's a grand spectacle for sure.