Does anyone know a site where I can find which games are CD and DVD's?

####://www.rapidbiz.com/ps2/dvd/

This is a database of DVD TOCs. Depending on how well maintained it is, games listed there are DVDs; games not listed there are likely to be CDs or DVDs not yet registered on the database. In the latter case, BOT's advice holds good, of course.