Haven't used it in production. I've seen some good stuff come out of it and heard its many praises. It seems like its users and devs really care about making a good bit of vfx software.

Unkindly, it looks like a kludged together unorganized open source monster with functionality smooshed every which way without consideration for how it actually gets used. Slightly better than Zbrush, which is a ui abomination.

Overall I bet it's fine and dandy if you take the time to learn its eccentricities. I fear it's very low on discover-ability due to the lack of strongly opinionated and efficient visual metaphors. But I haven't taken the time to dive into it to make a full and comparative review. Nor would I. I'm old and don't have the time or ambition to do so.

tl:dr Blender seems cluttered but ok. Use Houdini if you can, but Blender if you must. Death to Autodesk.