Does this thing REALLY work???

I didn't think about ever posting something here unless It were a success story but welp, here we go... I tried for over a year to get my SP crush. Nothing ever happened, at least in a palpable sense. We just ever stayed on the flirting phase, with glances, stares and such. When I would think things are happening and I am finally gonna win I'm shot in my heart by life. Every single time. In fact, things even got a little worse, and I'm not even talking about only my SP here. Talking specifically about my manifestation of her, time passed so much that I even managed to detach from her (It didn't change anything of my situation with her tho, detaching was the same as before) and I even got to talk to other girls, got some positive results that gave me some hope too. And even so, every single time, when everything IS going super duper well, I'm confident and am or feel like I am attracting the high vibrations, assuming positively, getting along with them, things just magically goes to shit, from one time to another. 80 to 8. I simply don't understand. And then when I try to manifest a result, nothing ever happens. Why? I already manifested unconciously so It's not like I don't believe on manifestions/shifting, I DO. But things just simply don't seem to go well to me. Do I simply repulse people? I'm at a lost. A girl I was talking to for example, things going super well with her being super responsive and nice (we even got to sext and exchange nudes), passed a WHOLE day texting, on the following day she simply started to give me single dry responses and not engage on conversation like before, simply got cold. She gives me no option other than to not insist anymore as to not bother her, because It is what It seems now. And like I said, this type of things happened on other times too. So, what can I do? What am I doing wrong? I used to robotic affirm, tried my very best to have a happy healthy positive mindset, expecting always the better outcome and such, being confident and taking care of myself but nothing seems to work. Nothing ever works for me and I never get anyone with my manifestations, anyone in a sense of REALLY having a connection, and even when I do, they just magically lose interest. And It was like this my whole life, not just now. I just don't understand how I can do better and I feel like giving up. I feel like failure for saying this as there's people who get It much worse than me but it's the truth to what I feel unfortunately. Anyway... This post probably won't get any attention I guess, don't even know If It will get approved but I kinda needed to speak I guess... Sorry If It demotivates anyone. Really sorry.