Personally, regardless of sport I only feel tension when I care about the winner. The game could be tied with seconds left to score and it’s no more intense than a pickup game between friends.
I feel the same. I watched (and enjoyed) lots of college basketball when I had roommates that were heavily invested in games' outcomes but never again since.