you have also this free one.. ;) D5 Render...another monster! :)
limitation to 16 k size image! :) Maybe less Objects possibilities animation than TwinMotion...depending of what you want...
You can also have a look at Light Tracer Render. https://lighttracer.org/
It's quite cheap (6.99 USD / month yearly plan or 99.99 USD perpetual license) and it can import Nurbs data.
It is limited in terms of animation possibilities though.
There is a demo version available
I can only recommend Blender.
You can follow tutorials to do what you want and move on, but I recommend learning it.
Its learning curve is not that steep. learning 3D in general is somewhat hard.
If you know 3D, then Blender won't take that much time to learn. If you don't know 3D, then Blender is the best place to start. Otherwise you'll be facing many problems and limitations with any software you use, and I'd argue it'll take you more time to know what you're doing and to learn the basics.
Also, Blender will be the future of 3D. I'd argue that its position is already cemented, but in the future, many horizons will open if you know Blender deeply.