WIY reminded me of something I should have said earlier.
I know how you feel. I suffered a major loss as a teen and for years I really couldn’t say Tehillim. For some reason it really hit me there, that it “didn’t work.” Then I heard something some years later. I can’t believe no one ever told me something so fundamental at some point, maybe it just really kicked in then. But what I heard is, no tefilla EVER goes to waste. Even if we don’t see the yeshua we need, the zechuyos of the tefilla is there, helping the one in need, in this world, or the next, or their family, etc., somehow, some time. I’ve participated in challah segulos for many different people. When there is a childless couple whose names I’m given, I have in mind that they should see their heart’s desire AND that my tefillos should help them stay besimcha, maintain their shalom bayis, and have a meaningful life till Hashem sees fit to do so.
I’m not Hashem’s accountant but there’s an account up there with all your tefillos that “didn’t work”, that makes any Swiss bank account look like some kid’s piggy bank.