If you don't mind sharing I'd love to hear which industry you're in. What I typically hear is advertising is Premiere, Hollywood is Avid, and Resolve is taking over prosumer/smaller shops (although still AE for any remotely sophisticated motion graphics/2D work). And Nuke for VFX compositing. I've actually never heard of Fussion itself being being popular for anything actually, it seems like it's not sophisticated enough to compete with Nuke, and not a great fit for the motion graphics/2D stuff that AE excels at.
Personally I'm mostly in web dev but I work with design shops, agencies, etc. I also do audio production, photography, and some video. But you're right that I'm in contact with small creative shops (less than 50 people).
> What I typically hear is advertising is Premiere, Hollywood is Avid
Yes, for editing, but AFAIK Resolve is quickly becoming the king for grading.
> it seems like it's not sophisticated enough to compete with Nuke, and not a great fit for the motion graphics/2D stuff that AE excels at
It's true but OTOH many projects don't need all that sophistication and you can't beat the convenience of doing it all inside a single project/app (editing, grading, vfx, motion, sound).