I've been backstage a few times - always because either I or someone I was with knew someone in the show. It's always great fun and a treat to see how things work - I always think it's important not to get overly invested beforehand though, because if I'm planning to be there as a guest of Ensemble Member A and suddenly Major Celebrity is visiting, well they're going to be the ones going back afterwards.
I've only once been invited backstage randomly, and that was at a local theatre. As it happened, I'd performed there myself (in our area amateur companies and professional touring productions use the same theatres) so was pretty familiar with the theatre, but it was specifically to have a closer look at the set since I'd mentioned it to a cast member I was talking to, so still a treat.