It's really just because you aren't a fan of the sport. I too find hockey more exciting, but I like basketball and it isn't entirely trading baskets the whole way through. There's running offensive schemes and seeing what works and what doesn't, seeing what combination of the 7-8 guys you have is working in a game, managing rest and foul trouble, running set offensive plays, reacting to all of those things on defense, etc., and then it often comes down to the last few minutes [and a ton of fouling that is a rule that needs to be changed]. But of course what's needed from each team in the last minutes was dictated by what worked and didn't work the whole time. I know you know all that because your posts all sound reasonable and thought out.
A basketball fan who hates hockey would make the same passing argument about hockey, wondering how people could just watch people skate around and just hit each other and barely score or celebrate. Like you said, people are different. Some people love jumping up and going "awww shit" a ton of times a game. There's a much bigger "posterized" enjoyment in basketball compared to watching something that resembles a more beautiful game.
And funnily enough, hockey fans tend to hate soccer, to which your description on the anticipation of a goal and it's beauty is even more apt IMO. People just like what they like. I do find hockey fans tend to be the most aggressive about hockey and it's ranking against other sports.