Man Shredder, that montage was.... frightening.
To the OP, depends a lot on the band, the fan base, and the individual player. In your average "real world" local band, I don't think it really matters. If you're playing covers for crowds to dance to at bars and parties, no one's thinking about how hot the bass player is.
For bands in the big time; bands like Rush, or any metal band, are pretty much guaranteed a 99% male fan base (and hetero male) - so the band's attractiveness doesn't count there either.
In most bands, all members of the band don't usually get equal attention. In the eye of the general public you have the singer, maybe one other front-row star (often a guitarist), and then it's just "the other guys." How many members of the general public remember anyone in U2 apart from Bono and the Edge? WE all know who Adam Clayton is, but to the average person U2 is Bono, Edge, and two other guys they can't remember.
It does give a career boost if the bass player takes the spotlight as more of a frontman, like Sting or Paul McCartney. Pete Wentz would be a great example of a bassist who's made his career more on being the good-looking frontman in the band (even though he's not the singer), rather than on musical ability (I'm not a Wentz-hater, I think he's fine, but you know what I mean).
I think it's harder on female bassists - even around here, where it's musicians, you can hardly say the phrase "girl bassist" without someone adding the adjective "hot." Granted, strapping a bass on gives anyone a major "hotness" boost - but I gotta wonder what it's like being a plain jane who can't pull off "hot female bassist."