Even Uncharted RF? That game isn't the least gory. Same goes with Heavy Rain, but that's either a love or hate type of game, so It's understandable. LBP isn't even gory AT ALL.
And Awww Tipsy, I love Assassin's Creed, I just got into it. Though I do understand where you are getting at, the game is a bit overhyped and I do think people claim it's much better that it really is. But I enjoy neither the less, and I would recommend it to you if you're into those kind of games.
As for games I dislike (I don't ever use the word hate…well maybe for Call of Duty, but anyways):
CoD series: Or at least Modern Warfare. Same reason as Tipsy, but I'm also not the biggest fan of FPS to begin with. But if I am, the game has to have a good story to it to get me interested and of course being fun. I don't find CoD any of those.
Halo series: Ok, I don't think these games are that bad, or at least the first. I played it, and it was ok, but still not my cup of tea. However, I do think it's extremely overrated! It's no where as good as other games I've played that are FPS, and let alone isn't that great of a game to begin with. Also, I would have just ended it at Halo3, but now we got a shitload of spin offs. I don't hate Halo, but I don't at all thing it's that great of a game.
Manhunt: Speaks for itself
SSB Bawrl: Don't hate this game, but it's wwaaaaay overrated. I prefer Melee over it anyday.
Those are the big ones though.
Though, just to reply to the Sonic 3D games: Not all of them are bad, at least the DreamCast ones, but they went down hill from there. Don't think Unleashed was too bad though, but I could due without the Werehog levels.
Still, I think 2D is where it's at for Sonic. If you haven't already and own a DS, go pick up the Sonic Rush series, they are fun 2D sonic games and I enjoy them very much.