Although, I still haven't picked this game up yet, Dragon's Crown for the PlayStation 3 has local co-op. The multiplatform X-Men Legends series also has good co-op.
DOUBLE DATE!
On the top of my head, this is what I remember having good offline co-op. Depending on what you hear, I've been hearing good things about Contra: Shattered Soldier on the PS2.
By the way, do downloadable titles count in your search for local co-op?