Blender
Official screenshots
A mature cross-platform suite for characters, environments, animation, materials, and promotional renders, with common engine handoff formats such as glTF and FBX.
Why use it
A solo developer can cover most of a 3D content pipeline in one free tool, backed by an exceptional tutorial and add-on ecosystem.
Where it fits
Use art, animation, audio, levels, and narrative to make the game easy to read and its world convincing.
What to check
Its breadth creates a substantial learning curve, and round-tripping proprietary formats such as FBX still needs validation in the target engine.