I just came across this tribute of sorts, a websitededicated to the art of Title Design. God knows I've listed plenty of examples on here, but this seems to be the end-all resource for this type of thing.
Check out some of these classics, and they just keep getting better and better:
This Is England (2006)
Sita Sings The Blues (2007)
Saturday Night Fever (1977)