It's a worthwhile question. Worth exploring.
I pretty much insist on keeping anything related to musical creativity: fun.
If I start developing an idea and it's not going smoothly - I don't necessarily quit when the going gets tough - but after some effort, if things are not coming together or falling into place and it becomes drag, I move on. Shelved to be revisited later if I get around to it or some epiphany hits me later.
Same with recording an otherwise finished or mostly finished idea. If it's not coming together relatively smoothly - like my vision of it is not getting realized - just short of full frustration I'll set it aside on either think on it for a while to see if there's a way forward - or just move on.
One of the things that drives my decisions and attitude about this is - at this point in my life - how little time I have for music. I have a demanding job and a busy life outside of music. So when I do spend time with music it needs to be stimulating and enjoyable.
And over analyzing and getting bogged down can be a problem too. I mentioned somewhere else recently - I have a MIL who is a long time accomplished professional oil/canvas painter (abstract mostly). We've talked about the creative process many times over the last twenty-five years. I asked her once: "How do you know when a piece is done?" She said: "I don't"
IMO, sometimes you just have to trust, I think. Don't over-judge. It's good to check yourself and not become obsessed with details. Objective outside opinion can definitely help with that.
But yeah.... my personal motto: "Music is fun"
Or - at least it
should be.