Honestly, a few months ago for me. I picked up the DVD, because my sister freaking loves it, so I figured I'd watch it with her, since she's always wanted me to see it.
I... didn't care for it. Sorry if I'm breaking some kind of rule, but I just found it boring. I normally LOVE musicals, but most of the songs in this didn't really endear themselves to me. And this movie was a bit TOO weird and nonsensical for me, and I'm usually all over the weird stuff.
I dunno, MAYBE if I saw it live, I'd think differently, but as of right now, I don't really see what all the fuss is about with this.
It's funny, I've seen a TON of other Tim Curry movies (even Clue), and I love basically everything he's in, except this.