You should almost always stick with an idea for longer than you think. I've had 3 successful projects (one making over 100K MRR[0]) IMO the main differentiator between winning and losing is how fast you are iterating based on customer feedback.

I think about it like throwing a dart at the dartboard. You might hit the bullseye in one shot but usually you'll just hit somewhere random then it's up to you to iterate and find the version of your idea that the market will actually pay for. This is the feedback part of the equation and giving up and throwing random darts may never pay off.

[0]https://www.zigpoll.com

were your projects in spaces you were familiar with? I feel like that makes the dart less random. Also I feel like it's hard to get customers/users on calls