I'm guessing your 150 block memory card was third-party. Don't take chances with those, just a heads-up.
Uh...the only Trannsylvanian game I can think of is Castlevania, which I doubt we'll see on the Cube. But for dark or spooky (or if zombies are an alternative to vampires :-D), definitely Resident Evil. RE4 is easily one of the most anticipated games out there right now, If I'm correct it's releasing early next year. For fighters, SCII is just about the best you'll get on the Cube, and for shooters, we've got all the 007 games (Rogue Agent's released this month), TimeSplitters II (I believe TimeSplitters III is comign out this month as well), and thoughit's not really a shooter, definitely look at Metroid Primes 1 and 2 (you got the demo for MP2, check it out). Zoids is pretty fun IMO, I guess that would fall under the shooters category. For RPGs, look at the newly-released Paper Mario II: The Thousand-Year Door and Baten Kaitos. Paper Mario's more for you, being an "occasional" RPG type, BK's more hardcore.
Hope that helps some.