This ofcourse differs with everyone, people like different things and have different styles, but just for another opinion, this is my current gaming library:
Wings 3D Modeller (free)
The Gimp Texturer/2D Art (free)
Adobe Photoshop Texturer/2D Art($$$)
Soft Image XSI Modeller/Animator ($$$)
Dark Basic Pro
Code Surge IDE for DBP (Free)
The ones that cost money arent required, but help with the developement process. If you're not interested in spending money, do a search for each of the free programs I mentioned and you'll be on your way to a good steady library, atleast in my opinion. The only thing missing is an animation program thats free, I use Soft Image XSI, but I believe Anim8or is free, Im not positive though.
Also check out Milkshape 3D, its not free but is really cheap, IIRC its around 20 dollars.