If your computer still has a gameport, the best game pad is the original Sidewinder (the best PC pad ever).
If you need to a USB type, there are 3 very good kinds. Xbox360 pad with 3rd party drivers, playstation pad with USB adaptor (3rd customizable driver preferred), and my personal favorite: sega saturn pad with USB adapter.