Thinking about making the switch from Windows to Linux, but I'm worried about partition management

So I already use Linux for work (mostly RedHat based) and I also use Ubuntu inside WSL and the package managers there are frankly lacking installing everything into the default directories.

I want to have clean partitions.

/apps for applications > 100MB. I don't mind the small stuff ending up in the OS filesystem hierarchy.

/games for games.

/data for personal data.

/temp for all transient files like browser cache and all that junk.

Everything else I want to keep as clean as possible -> Only operating system important stuff. I want to be able to wipe the OS partition without any loss of data. I also need full control over iOPS of the physical drives. And thirdly I want to be able to rm -rf a folder to uninstall an application easily, so for larger applications I don't want any fragmentation on the file system.

Can package managers support that in the year 2026 or would this be a nightmare to control with a gazillion symbolic links?

edit: Thanks for the responses, very much appreciated. I think I have a solution that could work for me with pacman --root which should work for my needs if I understand it correctly.