The reason I feel football and baseball are the best team sports ever invented is because both are designed around the achievement of, for lack of a better term, "mini-goals" as you progress toward a proper score. In football, this is the down and yardage structure. In baseball, this is the count, on base, and outs structure. These structures create a natural "narrative" build-up toward scoring (or defending) and add a lot more drama to non-scoring situations, i.e. can my team convert here on this 3 and 5 to keep the drive alive? Can my batter hold up here on 3-2 to draw a walk and put some pressure on the pitcher? Also fascinating is how the odds dramatically shift with each achievement or failure to achieve these goals. Ex. 3rd and 3 is totally different situation than 3rd and 8, as is a 2-1 vs 1-2 count in baseball.
Most other team sports don't "build up" like this. You either stop the score/possession or score/retake possession. In the common goal sports, there's no defined mini-goals in between to achieve or prevent that increases/decreases the odds of scoring.