The most hype and fall out of my chair moments come from fighting games (and Smash Bros specifically) but my favorite to watch is probably high level Dota. I haven't even played in 5+ years but it's still fun to watch how the game evolves.
Rocket League is absolutely the answer for watching without ever having played it. It's soccer with rocket cars, immediately easy to understand and enjoy.