The glory can come with a successful (or at least critically praised) film. Especially come awards season. Accepting an Oscar is about as glorious as it gets in the film industry.
But most DPs are looked at as part of a bigger whole. They're rarely singled out for personal glory, even if the success of the final product was mostly 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 will only be the best of the best that get that type of recognition. As glory goes, the average DP is smack dab in the middle of the spectrum. They get recognized but not much. Like that guy on Whitney. Usually the Director will get the credit for how gorgeous the film is, a situation that irks a DP to no end.