Any of the Time Splitters games had great split-screen. If you like sports games Pro Evolution Soccer 2006 has a campaign mode where you slowly grow players into stronger athletes etc.

I 'think' The Bouncer (Squaresoft Beat-em-up \ RPG) had co-op, Resident Evil Outbreak had co-op

argh my mind's gone blank, there's tons more I'm sure