One confusing thing is you said you saw psychologists and they recommended Prozac, but psychologists don't prescribe drugs, they do talk therapy. Psychiatrists or other physicians prescribe meds. So were you ever in therapy? According to your profile, you're 25 and live in Nigeria, and I"m pretty sure none of us know what's available there compared to the US where most of us are. Society can be very hard on people in certain cultures, so are you able to talk about this to your family, friends, and health professionals there? Also, rape isn't the same as an uncontrollable sexual urge, it's a different thing, more about controlling someone else usually. Obviously, there can be exceptions where someone is with another who says no and they push for a yes, but when it goes to force, that's violence, not sex. If you're going there, you need help right now. I hope the resources to pursue this is available to you. It's good you're pursuing help. I hope Mom has given you a good lead.
I have a suggestion for something to look up and see if it applies to you. It's called sensory integration disorder. It is neurological and involves faulty signaling from the brain. It's termed a developmental delay and there is a wide range of symptoms. It can affect people in different ways. Processing is involved so people may feel things and it's interpret as painful, they then avoid contact. Or they crave contact and firm pressure. Some have emotional regulation issues where they greatly over react. Or processing of issues where they don't get all the fine nuances of speech and 'miss the joke' or don't get context or true meaning of what others are saying. They have trouble with eye contact and conversation. They have trouble blocking out stimulus. Easily distracted and have little impulse control. They also could be sensory seekers. When kids they liked to spin ,bang into things, felt like they were 'climbing the walls'. Or they could be the exact opposite and avoid all of this. They can have low registration where they have trouble staying engaged and they then have various behaviors to do so like humming, moving, masturbating (also part of sensory seeking), eating spicy food, etc. It's complex. An occupational therapist works with people on this. Usually things are targeted in OT toward little kids, but there are plenty adults can do.
And sincerely, if you almost raped someone, it's time to get help. Regardless. You need go to strategies for impulse control. A therapist that works with ADHD would be able to help with some strategies even if you don't have ADHD and medication doesn't work.
If you feel, at any time, suicidal, please immediately reach out. I do think you need to begin working with a professional to get some skills to work through some of these issues. Hang in there.