Why are you comparing default behavior of macOS with Linux after “a bit of theming”. You can easily install a tiling window manager on macOS if that’s your thing.
But you don’t need to disable SIP just for tiling. I find it works extremely well.
> there's still a ton of tinkering and tweaking you need to do to get Yabai really working correctly
This is pretty much true of basically every tiling window manager on Linux, too.
For me, using Nix-Darwin for MacOS and NixOS has drastically simplified my tiling window manager setup after initially doing the work to figure out my ideal config.