I'm more of an ending theme lass, but my favorite intro is defintely Kumiko Noma's spiritual rendition of Lilium from Elfen Lied. I might get in trouble if I post it due to censorship these days, but the sensual, glamorous art is what makes it epic. The soprano, the Klimt references, the lyrics everything about it is profound.