No programs can truely be a stand alone but just another in the production pipeline for the end user. Where it fits in will depend on the user.
I don’t know…Blender seems awfully darn close. And while it has improved a lot over the last few updates, as far as UI and ease of use, it’s not exactly the easiest/friendliest program to use and there are things, that while it can do them, are much easier to do elsewhere.
The big question is, which is more important…being able to do everything or being able to do it easily enough that you can get it done within a reasonable time frame?
Right now, with just about all 3D apps…it’s pretty clear that even if it can do it all, there are other programs more suited for a particular task that allows one to work faster, than trying to do it all in a single program.