I found it very annoying and restricting. Most significantly being restricted to flatpak. For example I failed at installing whonix and couldn't get rust and vscode to work together.

If I didn't plan to get rid of by steam deck, I'd install a different distro in it. I definitely wouldn't install it on a desktop, support for the deck's keyboardless form factor is the only reason I might choose SteamOS over a normal distro.

Though I didn't know about distrobox then, perhaps that works better.

For development work you could try using toolbx or distrobox.

You can also use Nix or Homebrew to install additional software.