A Raspberry Pi multiboot lets you pick Raspberry Pi OS, Ubuntu, or MX Linux at startup without changing SD cards.
Linux's history is littered with distributions that came and went, many of which are long forgotten. There are some, however, that I actually miss, and these are they.
Sometimes, a somewhat obscure Linux distribution might be just what you're looking for. Is either CachyOS or Nobara the one?
A Linux home office server does not make you more creative. It removes the small, constant frictions that quietly drain you.