revert using platformdirs by default for windows and macos

[Gitznik]

Discussed in #1247

How would this feature be useful?

Makes the default behavior on Windows and MacOS more robust, by fixing some edge cases with sandboxing in windows and spaces in shebangs on macos. For more details, please see the discussion.

Describe the solution you'd like

Default behavior on Windows and MacOS reverts to pre #1001, for Linux it stays as is.
Revert the current path fallback behavior for paths in the pre #1001 location to fallback to the platformdirs locations post #1001 instead on Windows and MacOS.

Describe alternatives you've considered

Sticking to the platformdirs locations, as described in the discussion. There was no support for that idea though.

[Gitznik]

Should probably wait for #1281 to be merged as that will make this change a lot easier and prevent a lot of conflicts.