My favorite program is Lightwave, and has been for years. Lightwave is split in two packages, Layout and Modeler, and that’s the main reason why I started using it. Other people hate this solution. Please don’t expect very advanced modeling technics and tutorials, I just do what I need for simple video and films.
A typical Modeler layout showing the bridge from starship Voyager, my never-ending project.