Hello MC. Here's a list of most of the apps not including video-editing, that I use all the time.
Wings3D (freeware)
Carrara 7 Pro
Carrara 8 Pro
3DCoat
Bryce 5.5 (free) 
Blender 2.49 (freeware)
Illustrator 10
Painter 8
UV Mapper Classic (freeware)
Inkscape (freeware)
Irfanview (freeware)
Ivy Generator (freeware)
Gloodle (freeware)
Acme Brick Designer (freeware)
Arbaro (freeware)
POVTree (freeware)
Context Free (freeware)
Twig (freeware)
ParticleIllusion 2.0SE
With all the great and useful freeware and cheap but very powerful memory and computers it really is a great time to be a digital artist!