I got interested in this from CollapseOS and Collapse Informatics, imagining a day when we lose our ability to make advanced microchips, but still have salvagable ones laying around.
In terms of actual power, once you get the steam deck hooked to an external monitor with whatever peripherals you need like keyboard, it's just fine as a dev device, or for editing photos in dark table or running music production software. And, obviously, for gaming, works well, all in Linux.
In terms of using the onscreen keyboard as a "handheld dev device" I think one of those competitors with a miniature sized physical keyboard built in would probably be better, or there's a whole scene I glimpsed once of people making mini clamshell designs of machines with mini keyboards. The touchpads work ok but it's just infuriatingly slow compared to a keyboard, especially once you start needing brackets, parentheses, etc.