Fallout 3 isn't exactly what I meant when I said gory, and to be honest, it doesn't fit the bill as a 100% RPG if you as me, since it's 50% FPS, and I'm not a HUGE fan of the whole "Yay WRPG let's explore everywhere and forget the whole story" type of thing... I mean, sure there's gore, but it gets so boring and it's really unrealistic with it, I mean, I punched someone with the powerfist, in the chest, and one of his legs came off... I use VATS with the hunting rifle to shoot a guys right arm off, his left arm AND head came off... that's not what I wanted...
And when I say gory, I mean, God of War gory, lol...
Can't say I've ever played the Valkyrie Profile games, but I wasn't aware there was any blood/gore in them ? o.O