Hooking up a controller?

Well, until recently, I had no idea it was possible to hook up PS2, 360, ETC controllers to my computer. Or play games with them.

So I have a few questions;

How do I do this?

What games can be played with a controller?

And any other useful information.