I would recommend not giving up but instead altering your approach. I tried spaced repetition multiple times in grad school and completely failed at it. I then tried again over 10 years later (and much older!) and it was really like attaining a super power. The success is even more remarkable because compared to my university days, I am much less actively using the material in the cards.
In my case, the difference between the two attempts was sticking to the daily schedule[1] and getting better at creating relevant cards.
And keep in mind: SR aids in recall, not in understanding. There have been times where I look at the cards on a certain topic and do very poorly (consistently). I then realize it's partly because some key understanding has been lost. I then need to do a proper study session (get the book out, read for understanding, perhaps do some problems). After that study session, I get good on the cards and stay good for a long time. In the last 4 years, I've needed to do this perhaps twice.
[1] Yes, I do stop from time to time, but those are the exceptions, not the rule.
Once I realized that understand is different from recall, it made a world of difference.
I certainly wanted it to work, when I first learned about it I thought it was the answer. But I seemed to get worse and more stressed out because I wasn't learning anything.
I'm not too fussed about it not working for me. I don't think there is a one size style of learning.
Not sure if I'm just an outlier, but I think you're right that many learning heuristics aren't one-size-fits-all. Hope you can find something that's effective (and enjoyable) for you. :)
The more cards I created/added made it worse.