Specific individual advice for each person is very hard. Especially over a long distance.
So I don’t think I am even going to try. But I think I can simply share the fact that what you are describing is something I have experienced for the last 15 years. And at many points along the way I had moments where I thought, “This is crazy! What am I doing?”. But it is in my nature not to give up. And in my case, that turned out to be maybe not such a good thing. There is the concept of “sunk cost”. And at each difficult cross-roads I would say…“yes but look at all of the work and progress I have make…” And there is another term that fits here. It is good money after bad. It is kind of like gambling. (Which ironically I don’t do). And you can’t leave the table because of “sunk cost”. And you continue to put good money after bad.
So, for me, it was timing. And I did a lot of soul searching and I finally realized that things were not going to change how they have been going unless I changed how I was doing things. And a big part of that for me, was simply letting sunk cost be what it is, which is money time and effort I will never get back. Its gone.
The question I had to ask was, “Do I want to continue going down a road that has no real visible end?”.
And for me the answer was a resounding no. And it was hard. Additionally in my case I had a crew of 12 people to also convince of this fact. And not just right my own ship, I had to right it for everyone on the crew. So it was additional stress. After I had sold myself, I had to sell them.
What I had decided was a better way to work, was to work on smaller projects that I knew I could see a visible end to. Not in years, but in months. And to which milestones would be in the matter of weeks.
The hardest thing for me to accept was the fact that this “big large project” wasn’t going to be finished. Because this was something which could be sold. Finishing it would have meant “getting paid”, and recouping the sunk cost.
However it was unrealistic. So I decided, instead, that even though I might not be finishing large sell-able project, that I could gradually over time make smaller ones, that I could use to leverage more work, or more work in the area I wanted to work in. And that over time, gradually I would build up my business to the point I could tackle a large project, or better, find someone to pay me to make it.
So for me the solution was smaller bite-sized projects that could be finished.
Once I decided that, I was feeling very good about life. And I was not as stressed and unhappy as I was before.
My team agreed and we are moving forward quite rapidly on the first short, tangible project.
The key thing for me was “How can I take this smaller project and turn it into something that generates money?” I did find a solution. And that is not important to mention here, I don’t think. But just that this was on my mind and I did come up with something that I think is realistic, for me , in my situation.
But money or not, I find myself happier when I can complete things. And completely stressed and unhappy when I can’t or there is no end in sight. And that is probably the main take away.
Don’t know if this will help you. But for me the one additional thing was timing. I had to be ready to accept this. In the past I had the same idea. But I did not act on it. Perhaps because I was not ready to give up, first, in order to move ahead with a better plan.