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.