For the low-budget filmmaker who wants to look "shiny", your choices are either Blender (free) or Lightwave (not too pricey). Past that, you're in Maya territory which is much more expensive.
I haven't used the latest Blender but I've always fought with its interface. I love the Lightwave approach and they also have a super-friendly tight-knit forum community that helps out total newbies.