For a gentle introduction, start with this mini-documentary of a performance of Carmina Burana, in which they work with a conventional orchestra.
Next, for sheer exhilaration, watch Shou Shou Cheng. That was gardenfey's first link, which when it started rather reminded me of my father's approach to teaching me to swim: Throw me in and see if I sink.
Go ahead and watch it. I'll still be here when you're done.
Heart racing? Breathing a little heavy? Now imagine jumping up and down and all over the stage for seven minutes while all of your breath is being spent blowing into a fucking bagpipe. There's much to love about this band, but all that aside, it's the most amazing display of sheer musical athleticism I've ever seen — including the tapdancing bass saxaphonist I saw in Harvard Square one night.
How about a little dance number, familiar to generations of SCA-folk — saltarello ductia, perhaps?
Oh. My. God.
For something a more soothing, with production values that will definitely appeal to my SCA friends, I suggest Hymnua Cantica. (Yeah, knitted "chainmail". But if that lance shattering was CGI, George Lucas should hire their effects people. And a stadium full of people in Medieval drag doing the wave — how much more anachronistic can you get?)
Corvus Corax turns out to be part of a cluster of bands with shared personnel and similar æsthetics. How about a little bagpipe metal with Tanzwut? Or Ardor vom Venushügels cover of White Wedding — to which I had much the same reaction as the first time I saw Rocky Horror many years ago. (Let's say "erotic in unexpected ways", rather than the more colorful words of the Rocky Horror veteran who took the wide-eyed and innocent eighteen-year-old me to see it — largely, I suspect, to see if I'd break.)