I'll second the Thrustmasters that Famicommander posted, I have the Hotas X and it's a pretty decent stick for the price, and is also PS3 compatible which makes it AWESOME for Afterburner Climax. The only thing is that it squeaks a bit, I've been meaning to open it up and apply some joystick lube.
Alternatively, I played through Wing Commander 2 a couple of months ago using a Xbox 360 controller and Joy2Key. The thing has enough buttons to map everything without having to use a keyboard, it was pretty rad, but naturally not as good as a good fight stick.