DPs are completely behind the scenes of a film. Not only do most people not recognize their faces, they've never even heard their names before. Even the most diehard film geek would be hard pressed to tell you the names of more than one or two cinematographers.
Winning some of the major awards (like a Golden Globe or an Oscar) may give a DP a brief bit of fame, but it's definitely fleeting. The average reality show contestant is better known than the best cinematographers. Fame is definitely not a perk of the job.