Blender covers almost the whole 3D pipeline in one app, and it costs nothing. A large community means there's a tutorial for nearly anything.
Best for
- Product shots and 3D illustration.
- Motion graphics and short animations.
- Learning 3D without paying for a licence.