I don't play games, but every time I edit a video I think I ought to upgrade my PC as it's pretty old. It has plenty of memory, but you need CPU and/or GPU to do this stuff efficiently.
In our old house I used to have my computer in the spare room. Then child one came along and I had to shift it into our bedroom. When we eventually built our current home I made sure I had my own study that is also the music room. I just should have made it more sound-proof :)
A few years ago, I was delighted when we moved into a new place, and they had this tiny room that I was able to use as an office/ storage room for things I didn't want in my bedroom. Sadly, I don't have a space like that where I am currently, but hopefully, soon we'll be able to move out and into our own place.
A few little upgrades wouldn't go amiss, and for Music production and sound design, you wouldn't know yourself if you had something nice and nippy. It doesn't even have to be too wild: a decent GPU that's compatible and a good M.2 hard drive, and you'll be flying. You can get some info on your hardware you've got now, and there's a site you can add everything to, and it'll give you a list of compatible parts that you can pick up. That's how I managed to build my machine; otherwise, I wouldn't have had a clue. If you're buying a new CPU, it would probably be easier to buy a new motherboard too.
You're technically minded yourself, but if you want a bit of help, I don't mind looking into it too and helping you pick some parts.
I've built loads of computers, but I'm out of date on current hardware. I was looking at a local company who builds them. I could take one of their setups and customise it to my needs. I would go for a tower as I have a few hard drives I can use, but I know NVMe is the in thing for fast storage now. I think some video software can exploit graphics cards, so that could improve things a lot. What I have now is so old that it is not worth upgrading. I will probably look for something next year.