I was in the same situation as you, even worse, my switch is hooked up to our TV, charged and ready to go, but still haven’t gotten much use.
If it weren’t for my wife getting it for me I probably would’ve skipped the Steam Deck and I wouldn’t have been able to game as much as I had since getting it.
I’ve had it since November last year and I’ve finished KH1, KH Re:CoM, KH2, DMC V, and am currently playing Nier Automata. It’s such a fun little device that allows me to squeeze in some gaming between work, taking care of a newborn, and other chores.
If you have a steam backlog you’ve been itching to play, I’d say definitely go for it. Otherwise, if you find yourself wishing you squeezed in a 5 to 10 minute gaming session during idle times, I’d say that’s a good indicator a Steam Deck would be a good purchase for you.
For Python, VS Code and Jupyter Lab. I used Sublime Text 3 previously but have found VS Code to be easier to set up and better supported over time. I do miss how fast and lightweight Sublime is this compared to VS Code though so I still use ST4 as a general text editor.
For Excel VBA (ugh), pretty much have to use the built in one as there doesn’t seem to be any alternative.