If you look at sports as anything other than entertainment then you're going to get upset. Why do we like our athletes drug-free but our musicians drug-ridden? (Does anyone REALLY like bands after they sober up?) What really matters is what kind of person you are and what you do with the money you're given.
The problem seems to be less that the athletes themselves are unlikeable, but more that their agents create unlikeable situations. There are no real teams. There are people who play together for a season or less then move on. Sports used to be a team game and players were known by their hat. Are you a fan of the team or of their logo? I'm a Cubs fan, but I can't think of many active players who have been on the team for more than a few years.
So I'm a Cubs fan, what does that mean? That one year I like Damian Miller but now that he's a Brewer I need to dislike him? Look at Football. Do you like your home-town team or your fantasy football league? Are you a fan of teams or players?
I love baseball. It's a team sport, not a two or three player combo. Everyone needs to perform both offensively and defensively in order to win. There's no such thing as the Brady-Moss combo in baseball. Or the Pippen-Jordan combo.
Basketball - now there's a crappy sport. No one plays Defense. It's all about who can put the most points on the board, not who can prevent the most points.
Superstar agents, hundred-million dollar contracts, human nature. These are what mades sports boring.