I really don't think being famous makes a guy more attractive. There are barely any famous people that I find attractive; I much prefer everday 'boy next door types'.
My flatmates are always looking through celeb mags, watching films, or pop stars on TV, and commenting on how fit a lot of them are; but most of the time I really don't see it.
Maybe it's just that it seems like a guy is being considered more attractive, just because he's noticed/recognised by more people? I mean; how many guys in your everday encounters are recognised by almost every girl they pass in the street, and discussed by people who don't even know them? I think it's just that they're in the public eye and get noticed more. Hence why someone fussy, like me, doesn't see the attraction of many famous guys, where my flatmates do.