Yes, almost all games require the CD in the drive.

I know people though that hate having to put the CD in the drive, and even though they own legitimate copies of games will still download no-cd hacks so they don't have to.

I generally just play one game at a time though so it is not an issue for me - I suppose if you have several on the go at a time and have to keep swapping CD's it could be a pain...