Awesome Music: "Forsaken", "Redeemer" and "Slept So Long" are particular high-points, although it must be said that the entire soundtrack is pretty damn awesome. The original songs were written by Jonathan Davis of Korn, and were performed by Chester Bennington, Marilyn Manson, and David Draiman (among others).
Covered Up: Five of the songs on the soundtrack were written and recorded by Jonathan Davis of Korn. Due to contract troubles, all five songs were covered for the official soundtrack, by the likes of Wayne Static, David Draiman, Marilyn Manson, Chester Bennington and Jay Gordon. Unless you've seen the movie (especially the music videos included as extras), most people think that the covers are in fact the original versions of the songs. And considering how hard it is to get a hold of the original versions, since they were never officially released, this doesn't look like it will change any time soon.
Damsel Scrappy: Jesse is sometimes accused of being this, due to her penchant for wandering blithely into obviouslylife-threatening situations, despite being totally unable to defend herself and inevitably needing to be rescued.
Draco in Leather Pants: Lestat again. Probably aided by the fact that he does literally wear leather pants for most of the movie.
Fan-Preferred Couple: The fandom in general favors the vampire/vampire pairing Lestat/Akasha over the vampire/human pairing Lestat/Jesse. This despite Akasha being portrayed as pure evil and a bloodthirsty megalomaniac who wants to drink the world dry, Akasha had Evil Is Sexy going for her while Jesse was made into a Damsel Scrappy and mousy Vampire Vannabe who just got on viewers' nerves.
Franchise Original Sin: As explained here, Maven of the Eventide feels that a lot of went wrong with the film adaptation of Queen of the Damned can be traced back to its much better predecessor, Interview with the Vampire. In Interview, Lestat was a vivacious, lively character who mocked his brooding counterparts, yet those "tortured souls" still came off as sympathetic characters due to their development over the course of the story. Unfortunately, the makers of Queen mistook that as "brooding = sexy and cool."
"Funny Aneurysm" Moment: Akasha's death is a great deal more disturbing than it would otherwise have been, given the fact that the actress died less than a year after filming the movie, at the age of twenty-two.
Ham and Cheese: Aaliyah, Stuart Townsend and Vincent Perez all seem fully aware of how silly the movie is, and they all look like they're having a great time chewing on the scenery. Townsend and Aaliyah in particular really go to town with it, making ridiculous overblown gestures and milking relatively mundane lines to the point where it's damn near hilarious.
Narm: And lots of it. The movie doesn't appear to be taking itself at all seriously, so much of it may be a deliberate attempt to invoke Narm Charm.
So Bad, It's Good: It's really... not great if taken as a sequel to Interview With a Vampire. On its own merits, however, it is full of cheesy goodness. The awesome music and copious amounts of shirtless Stuart Townsend don't hurt either.