I can't say I've been there, but as another person on the Internet, I can say that sometimes failing a lot is the only viable path forward and it sucks. It's the famous quote about the invention of the lightbulb, it took over 1,000 attempts to get something that worked well, and when asked what that felt like to fail so many times, Thomas Edison is attributed for saying, "I didn't fail 1,000 times, I discovered a thousand ways not to make a lightbulb."

So I guess I'm saying to keep finding ways that don't work and I hope you do get your lightbulb soon!