Here's some info. I'm on the PS3. I have Uncharted 1, 2, Assassin's Creed, 1, 2, Brotherhood, Killzone 2, COD4, MW2. I don't really feel like buying another COD. I like shooters, RPG's, whatever really.
As long as the game will take a while to complete, it qualifies. Thanks for any recommendations.
Yakuza 4 is released this week, might be interesting for you. There are supposingly a lot to do in that game so while the main quest "only" is ~25 hours, it will take a lot more to do all side quests and so on. That said, if the controls are like in the previous games, they feel a bit outdated and not so smooth as some western blockbuster games. Or you could just go for the cheaper Yakuza 3 which was released about a year ago.
There's also Fallout: New Vegas if you haven't played that one already.
My favorite PS3 game is still Valkyria Chronicles which was released back in 2008. Great story and fun gameplay and so on, highly recommended ^_^ And then there's Demon's Souls too if you want a fun challenge. Oh, and Nier is excellent too.
So check those games out and see if any of them are something you might have fun with