Dead Memories - Ulduar was created by Endac to display Ulduar to those who have not seen it, or maybe to show off his guild's skills in dominating the raid instance. He created his video with a twist, however. Dead Memories - Ulduar is shot through the perspective of a single visitor, who's plagued by nightmares and dreams about the place.
Endac says he doesn't think his video is "super fancy," but I actually think that's fine. His movie is straddling a line between machinima techniques and raid video techniques. I like the sense of wonder and (sometimes) horror his main character emotes to the audience, even while navigating through the terrific battles inside Ulduar.
The music choices make sense to me, even if they aren't necessarily my favorite bands ever. Your mileage will vary, of course, but I think Ulduar deserves a metal soundtrack. If you're particularly opposed to metal, you might find the soundtrack distracting.
Ultimately, I think Endac's video is pretty neat. I'd encourage him to take his storytelling to the next level, though, as he and his guild explore new content.
Edit: The initial link was broken -- it has now been fixed.