Blender is the tool that bet matches what you want.

It's free.

*Programming is done in python that only takes about a week to a month to learn.(If you can already program)

*Has all of the geometry tools. Blender's spline modeling needs work, however as a person who often has to clean up models of other artist I wished spline modeling will be banned. Spline modeling is dirty, you always need to clean up when done and it is often faster to just make the same model using a different style of modeling.

Blender makes up for it's lack of spline modeling with great tools for the other modeling styles.

*Blender can be used to make corridors, rooms and any thing you can think of.

There are software that will make fully furnished rooms with a few quick steps, they use preset meshes that won't work in most games as each game has it's own set of parameters. Also making levels with software like this will cause all the levels to look the same and can also brake license agreements.

*Blender is grate at making curves and advance forms, it only needs the modeler to know how. Damage can be modeled or sculpted.

*Blender has a smart UV project option that is as good as most Auto software. There is no software that can Auto unwrap any mesh without some kind of loss in quality.

If software like that existed I would be using it, UV unwrapping is %50 of modeling.

*Blender can give you a openGl preview, but with modern engines like Unity and Unreal it is best to view the model in engine as fast as you can.

*Can import and export all standard formats and a few obscure ones.

*Yes can subdivide, auto and manual.

Like I tell my customers tessellation is only good for organic shapes. To make the height map the modeler has to model every brick, then the tessellation has to divide the mesh into thousands of polygons to show those same bricks, each brick can be made for 10 triangles. It is cheaper to have a wall with every brick modeled than to have a wall using tessellation to show every brick, it's also faster to make.

*Clean meshes depend on the modeler not the software. Although sub-D modeling is considered to be the cleanest and can be made with Blender. Spline modeling is dirty, so the modeler has to clean it after making the mesh, it takes a lot of time so modelers will often pretend to be to busy to clean the mesh.

*Did I mention it's free?

For your game engine I recommend Unreal or Unity, in that order. There are others however Unreal and Unity is the best, in that order.

Panda 3D was good for small games.

Lightwave is good for rendering, if you where making a movie I would recommend a Blender+Lightwave combo; because Blender has better mesh tools.

For games I recommend Blender.

3DS Max is like Blender+Lightwave it has all the mesh tools and the render tools.

If learning Blender was frustrating don't expect any other software to be better, it takes 3-4 years to learn how to be an average 3D modeler and all the software use similar tools.

If there was some software that could make 3D models, by a touch of a button then there would be no use for a person; you can program a computer to press it's own button.

If you find Blender to be intimidating, might I make a recommendation? On Udemy, there is a course called 'Learn 3D Modelling - The Complete Blender Creator Course' which is pretty cheap and will get you up and going with Blender better than anything else I'm aware of. The main instructor does a stellar job, and of all the other Blender related courses offered by Udemy, this one stands head and shoulders above the rest. The content is massive, and it is all of the highest quality. One of these days I need to go back and finish it :-)