Edit: it happens to me with porn stars, actors, writers, directors, etc. The more I learn about people the less I like them, and the less I enjoy their work.
I totally get you. I am also been having this experience for at least the last fifteen years, that all the creative persons, actors, etc that I used to admire and look up to turned out to be such disappointments.
Not always when they started. Sometimes from the interviews and articles they seemed to be the people I thought them to after I discovered their creations or works, but then this moment happens in which they do a 180 degree or perhaps just a 90 degree shift and can become absolute A#####, become nasty towards their fans, completely stuck up, act as if those who do not share their viewpoint or have not accomplished anything on their level, or simply people that don't meet their standards are beneath them.
And it makes me wonder what the hell happened? Were they always like this but did they mask it very cleverly, have they grown arrogant or bitter? Have they grown detached and non caring?
In the end though some of it may still lay with us, the people or fans who liked what they did and praised them and developed an image of them.
Seeing this behavior though from for example game designers has cured me of "hero worship" though. Whenever I see the name of a designer whose work I used to like it does not automatically make me think any more "Wow, whatever this project is that they are announcing, it must be great."
If anything it only makes me wish that I become a creative person of my own, make or do things that I enjoy. Then I only have to live up to my own standard.