I've been using my Steam Deck as my primary PC both at work and at home. Very few issues. I have two monitors, power, ethernet, keyboard, and mouse all connected via a USB-C dock. I love that when I'm done with work I can unplug one USB-C cable and take my work with me. I also have an electric car, and I love being able to play my PC games while waiting for my car to charge.
As a web developer one of the biggest hurdles I had to jump through was getting MySQL Workbench running, as there's no flatpak or working AppImage available. The lack of CUPS for printing support is another nuisance, but I believe that can be overcome without unlocking the root partition by installing it as a systemd extension. I haven't taken the time to fully prove this theory though. You can also print using netcat.
I installed a 2TB SSD in mine. I have a small 256gb Windows partition that I rarely use for the few things I need Windows for. I also DJ as a side hobby, and I've used my Steam Deck for that too.