What is an awesome coop game?

I'm looking for a game I can play with my friend that has a fun campaign. We liked games such as Dark Alliance or LOTR:The third age. We have a few CODs and the first 3 halos and we don't want another one of those games. Basically, all we want is a fun rpq game to play. The consoles in our possession are Xbox360 and playstation 2. Name a few games if you can. thanks.