I found working with AI as the code buddy to be motivating (ironically). You get to chat about the project, ask opinions and in general have somebody do the work you don't find inspiring.
AI often doesn't do things your way, but if your doing something for yourself you usually care more about the goal than the technicalities. Also AI working on a hobby code base is less prone to overcomplication since it basically copies what you've wrote yourself.
I had a similar experience. Just chatting about stuff, shooting ideas and concepts back and forth with the AI is quite stimulating. I get to be an obnoxious help vampire without draining other humans of their patience and motivation. It's like having a developer friend with infinite patience to chat with.
In terms of productivity it's having something of a mixed effect. It gives me very clear ideas and direction but at the same time everything just feels done afterwards. All that's left is actually executing the tasks which is... Boring.
I'm not sure I trust ChatGPT to do it for me like an agent. The examples it gives me are never quite right. It's probably a lot better at generating frontend javascript code than programming language interpreter code.
AI often doesn't do things your way, but if your doing something for yourself you usually care more about the goal than the technicalities. Also AI working on a hobby code base is less prone to overcomplication since it basically copies what you've wrote yourself.