I've been on and off with tiling, but mostly off, because it keeps being more in the way and shuffling around windows than I want it to, but every now and then I want to select 2-3 windows and say "tile them like this, ignore everything else".

I've recently discovered an interesting hybrid approach that goes beyond "snap to (maximise|half|quarter)", which is implemented by the app divvy[1]. It can show a small grid on which you can draw a rectangular box that the active window then snaps to, so it makes "manual ad-hoc tiling" quite easy. Probably easier to watch the demo video than try to explain it in writing. It's sadly a bit expensive, and I'm also not sure how actively supported it is. Also no version with X (/Wayland) support.

I think the best and most flexible solution might be some kind of middle ground like that, with stacking by default, but quick and powerful tiling on demand.

[1]: https://mizage.com/divvy/