Same boat except my Arduino and Pi devices are still gathering dust (but I do want to eventually get a general, foundational knowledge of electronics). My own ideas most often devolve into timesinks that leave me questioning how I even convinced myself to start down that road. I like doing dev stuff more if it happens when an update breaks something, like a service or a plugin to some app I host. "Hey, that's a goddamn puzzle! I fucking love puzzles!" And there's the underlying fact that, if I manage to solve it, I might be helping somebody else out. Some psychological compulsion to help others that I can identify but still not deny.
Anyway, I might never end up a "contributor" to anything else but one of my biggest highs was singlehandedly debugging, submitting, and having a fix merged to a Jellyfin plugin I use. From first reporting it and thinking out loud about it in the app's Discord, to poking through the source on GitHub (in a language I've never touched), I worked it out in a few hours and even compiled a replacement .dll for my own use until the merge was accepted. To the reception of some compliments and pats on the back from regulars on the server that, at the risk of over sharing, did more for my emotional well being than my last lay. The problem ended up being a simple order-of-operations issue but the experience was the sort of the thing that makes a guy, who hasn't worked so much as a help desk position, briefly think "Maybe I could hack it."
Conversely, my biggest low was wasting 45 minutes on an Advent of Code problem because I forgot to switch from the sample data to my actual puzzle data in the second half. It was a first-week problem, probably child's play for any pro, but I had a working solution fast enough to have landed on that day's leaderboard. It would've been entirely self serving and good for nothing but bragging rights. Instead I wasted nearly an hour to reach the "duh" moment and subsequent self loathing. I wanted those bragging rights!
The TLDR is Programming turns bipolar disorder into a speed run session too easily for it to be more than an on-again off-again hobby or the occasional necessity for me. I can't fathom how the actual pros, especially those in prestigious and lucrative positions, keep from crashing out or falling into imposter syndrome any time they let themselves get caught up in an off-by-one or some other nonsense.
Now that is an ambition to strive for! Easily one of the most significant communal projects of our time which, despite still remaining almost unheard of to countless people who unknowingly rely upon it, would be such a remarkable honor to take part in.