The glory in this gig comes with a successful (or at least critically praised) film. Especially during awards season. Accepting an Oscar is about as glorious as it gets in the film industry.
But most DPs are looked at as just one piece of a bigger puzzle. They're rarely singled out for personal glory, even if the success of the final product was due to their skills.
That being said, if the film is gorgeous, the DP will get some recognition for it inside the industry. But even then it'll only be the best of the best who get that type of recognition.
Otherwise, you'll just have to live with the personal knowledge that a lot of your work went into making the movie blockbuster of the summer. Everyone's talking about how beautifully it was shot, even though they don't know your name. Woe is you.