I've never pursued any formal diagnosis and just have the observations of my own mind to go on, but I have a lot of common ADHD symptoms and I do sometimes have the kinds of manic phases you're describing but not to a debilitating severity. It's just this state of high energy, usually for me involves creative output, and yeah other previously important goals wind up feeling secondary.

Happy to sacrifice sleep, etc., but I don't usually make damaging decisions, I'm able to keep my broader priorities in mind at least. Better today than I used to be at that but it never really caused me big problems.

But it feels a lot like a mild version of the comic - my last one was a big, kind of involved Halloween build. Wooden construction that included lights, a fog machine, and a 3'x3' sheet of plexiglass with a big printed decal. I've never designed/built a Halloween decoration in my life, or much that's very similar. Other times it's a software project, or something musical. Kinda thing that pulls me outta bed in the middle of the night for no real reason, just (almost annoyingly) stoked. Until it passes.

No idea what that says about ADHD and the broader "symptom creep" you're describing (imo, accurately).