I loved Faerie Tale Theatre as a child! I was too young for the tv airing, but my library had many of the episodes on vhs. My favorite as a kid was The Dancing Princesses.
I bought the whole series on DVD a few years back, and would especially recommend Sleeping Beauty with Bernadette Peters and Christopher Reeve, and The Princess and the Pea with Liza Minnelli. Both of these are hilarious. There are many other enjoyable ones too.