I've never heard any authoritative source suggest that ED and impotence are two different conditions. What you're reporting is technically called anorgasmia, I think. According to the Harvard study reported at the link below (no connection), effective drug treatments for anorgasmia haven't existed, but a new one shows promise. Have you brought this up with your doctor?
Besides the pharmaceutical approach, if "getting into a trance and having my partner tell me to relax and let the orgasm flow" works, that suggests that it might not be primarily physical and that some kind of meditative or Cognitive Behavioral Therapy type approach might be worth looking into. That's not up everyone's alley, of course, I just tend to go there because I'm (maybe overly) leery of taking pills.
There is an herbal medication that has long been reputed to enhance sex, of course, but our wise rulers decided eighty years ago that it was a soul-destroying scourge far more dangerous than alcohol, tobacco, or firearms, so far be it from me to recommend it.
And I'd say Viagra and Cialis are marketed to younger men, older men, docs, anyone the drug companies might be persuaded to buy or prescribe them. And you're right, they just help you (if you're lucky and they work for you) get and keep an erection once you are horny; they don't do anything to get you there.