I've never played the sport beyond a limited-contact flag football league, but I agree with your sentiment. It takes a lot of time to really get to know the game, and if you really like the sport for what it is it's suddenly not so bad to root for a terrible team.
It is kind of a bummer that you rarely get to see all 22 on a broadcast, because the camera stays fixed on the ball carrier. It can be hard to tell if a quarterback is having a bad season because he sucks or because none of his receivers are getting open (though any sports blog will be happy to give you an opinion).