Blender is completely amazing. Don't knock it till you've tried it. Just because every other 3D package is bloated doesn't mean Blender has to be
I'm not intimately familiar with Maya or 3DSMax, though I'm sort of familiar with SoftImage; Blender can do pretty much everything that SoftImage can do, and as far as I know it's at least as capable as 3DSMax and Maya. And it's free (speech and beer)! Anyway, if you want to know what it can do, visit the website
, and check out the features list and galleries.
And yes, POVRay is just a renderer. Best raytracer out there, and sure, it can produce output that looks as good as anything else, but it is not a modeling package (unless you consider hand-coding in a scene description language "modeling").