I'll try to list as many as possible
Maya - Expensive
3DSMax - Expensive
Houdini - Difficult and very expensive
Lightwave - Moderate
Cinema 4D- Moderate
Poser - Generates models, so lack of originality but average priced
Softimage XSI - Average/Moderately priced
TrueSpace 7 - Needs a powerful PC, Moderately priced
TrueSpace 6 - Like 7, but doesn't use a next gen scene renderer, so you don't need a powerful PC
Carrara - I don't know much about this, but it come free with this months 3D world Magazine
Blender - Free, powerful, harder than most
Anim8or - Free, Doesn't compare in power to other applications in the market or Blender, not very good for games, but is easy
Hash Animation master - Looks great, cheapish, its powerful, it was used to make those adverts for Tak: The power of Juju, no demo, but the website is full of animations and renders.
Shade 7 - Cheapish/moderate, I don't know much about this app
EIAS, again I don't know much, Moderate price
Strata 3D CX, Just another app listed
Price key
Very Expensive up to or over £8000
Expensive - £700 - £5000
Moderate £300-£700
Average £150-£300
Cheapish £70-£150
Cheap £1-70
[Edit]
Maya was used for Ice Age 2 and many similar movies
3DS Max is more widely used in the gaming industry, Prince of Persia i s a good example
Cinema 4D was used in Gladiator, Van Helsing, The Polar express
Softimage XSI is more game used, like Metal Gear Solid
Poser is generally associated with perverts(Just look at Renderosity.com with all the poser models
), but is usually used for simulations because the person doesn't need to worry about modelling
K I changed my name into a famous Samurai, but meh! Seppuku got boring after a while