You can easily install and configure a tiling window manager on any distro, so you should not switch an entire distribution and your base because of that. Unless off course you want to, but its not difficult. If you install a tiling window manager from your repository, then read the documentation how to set it up correctly and log out your current user session. Then in the login screen, you should be able to select what window manager or desktop environment you want to use.

But be careful, lot of window managers are still not supported in Wayland and the other way, some of the new window managers are Wayland only. The usual suspects would be probably Sway or Hyprland on Wayland? There is also Qtile, but that is for people who want to configure and write Python source code, as the configuration is in Python language (BTW my favorite tiling window manager, but not for everyone). EndeavourOS used to have a Qtile spin, but they stopped that not long ago.

But if you really must switch the distribution, then there might be a few preconfigured tiling window manager distributions:

• Fedora with Sway (on Wayland): https://fedoraproject.org/spins/sway/
• Fedora with i3 (on Legacy X11):