Castle Crashers!

The last few Call of Duty games also have really fun co-op, well designed roller-coaster campaigns, and still have decent communities on Xbox Live. Most of them are probably really cheap now.