When I was young I was active in the demoscene but I knew few other demosceners in person. Needless to say, I looked up super much to many demomakers, genius programmers/artists who seemingly could create madly impressive works out of thin air. It was as if they could convert dreams into code, or something [0].
Then gradually, after visiting more demoparties, I got to know some of these gods, and without exception, they were super nice. I ended up collaborating (gasp) with some of them.
I'm convinced that if you're popular and you're overrun by fans every day, it gets tiresome. That's where that saying comes from. But I'm sure that your favourite knitting youtuber, or your physics teacher, or that amateur Ambient Techno Metal producer on soundcloud you're totally mad about, they really don't get fan mail often enough. Reach out.
[0] eg https://www.youtube.com/watch?v=VvPriI0sTwQ how??
In another case, the developer of one of my favorite games, Fez, seems to have garnered a certain unfavorable reputation, that, whether warranted or unwarranted, comes up in most mentions of the game.
That saying is more a warning against such disillusionments than about never reaching out.
But in reality, some people are nothing like what their public image suggests (i.e. they might actually be fairly unfriendly, negative, unwelcoming etc).
Of course, that 'hero' might also just be having a bad day or was feeling tired when their fans approached them - which is sort of a flaw in the whole "never meet your heroes" idea.