I actually think AI development is going to close a lot of these gaps faster than people think.

And I think the options for audio and office are pretty decent, LibreOffice definitely does all that I need and there's a healthy community of musicians and audio enthusiasts building things in Linux.

Hardware design and CAD have the additional blockers that they require physical manufacturing and open source hardware has a long, long ways to go. Without an ability to actually produce the physical goods, open source software doesn't go anywhere. Kind of a bootstrapping problem.