Most important part first:
1) ANYTHING that can 'cause' insomnia as a side effect can ALSO cause cause sleep or excessive sleep. It depends on how your brain processes it.
2) Ignore the 'names' of drugs / classes except for your prior reactions to them. Neurochemistry doesn't care what a medication is "supposed" to do. Everyone's neurochem is different. That's why nearly all side effects listed include the OPPOSITE reaction AND AND AND why meds are prescribed 'offlabel'. A drug company has no incentive to label the best antidepressant ever as an antidepressant if they already have a best seller. If, instead, it also works as antianxiety, they'll label it where they aren't making much money. After 5-10 years of "round 2 human trials" (the first 5-10 years when it's on the market after being approved)... it will be used mostly as an antidepressant, because that's where it shines. And the "antipsychotic" that is a stellar antianxiety drug will get used as an antianxiety drug. And the ADHD med will be used for Anorexia, and the seizure med for a mood stabalizer, etc. IGNORE WHAT IT SAYS IT'S "FOR". What matters is how YOUR BRAIN/ BODY REACTS TO IT.
3) I know the fear, when you can't sleep, of doing anything that might make sleep even more elusive. It's hard to get over, but it's WORTH IT to find what actually works with your system. I reason "I'd be up anyway" and "I can do 24 hours standing on my head" AND have someone else with me the first 3 days of any new med. That's the key part, right there. As long as someone will stay with me, to make sure I don't go loca... I'm able to get past my fear.
_________________
I'm ADHD, so my brain -off the bat- processes meds differently than most people. Stimulants have a habit of knocking me out, and many depressants have a habit of 'wiring' me. It's not a 'true' paralell. Some stimulants will keep me up for days, and some depressants will knock me on my tush. But as a general rule... a stimulant is going to make be very chill, and a depressant will have me table dancing.
SSRIs and SOME Benzos (like Xanax) both knock me on my tush. Not much else does outside of anesthesia drugs and schedule 1 stimulants.
Benedryl will SOMETIMES. Not if I'm doign a true insomnia run, but just the ADHD-not-set-to-a-24-hour-day thing (My body is really on a 36 hour clock, instead of a 24 hours clock, so I have to/choose to reset it from time to time). I can 'reset' my clock for a month or three by taking benedryl 30 minutes before bed for a week, and often do. Benedryl doesn't even begin to touch true insomnia for me, however. It just makes me twitchy. Very little is worse than being awake and twitchy. Oy. It's so ANNOYING. But I digress.
The ones you listed above? Ha. I could list off what most of those do to me.. actually... I will:
Clonopin, Lorazapam, and other benzo's don't knock me out, but I'm also not able to sleep. Awake, awake, awake... just not freaked out about being awake (you know how anxiety tends to skyrocket when you can't sleep? That goes bye bye, but the sleep doesn't come).
Trazadone = Happiest tired but AWAKE person on the planet. I can't sleep on it. Also can't think. I'm just a happy zombie who is EXHAUSTED and wants desperately to sleep an can't. Even worse than before I took it. It's awful.
Seraquel and other 'mood stabalizers' or 'antipsychotics' in general push me into psychotic manias. It's how ADHD folk are often mislabeled as Bipolar. Antipsychotics CAUSE psychosis in ADHD folk. Bad juju.
Ambien and Lunesta create waking night terrors. I can't sleep, but am half in dreamland OR I'm paralized but awake. Very scary.
But antidepressants? Out like a light. Xanax? I barely have time to get from the kitchen to my bed.
It's not that I'm 'depressed', It's that my brain, when I inhibit the serotonin from being absorbed as it usually does, flicks the 'sleep' button in my brain. That's really common for ADHD folk (but not universal). It's part of why so many ADHD folk take antidepressants. It's NOT that we're depressed :) It's just that they let us sleep.
I take neither regularly, but if I end up in a major insomnia jag I can and have taken either xanax or prozac and squash it like a bug. My insomnia will run for days (36 hours without batting an eye, and 4-5 days if I'm really unlucky), and a true jag lasts for several months. It's a PTSD side effect that crops up now and again with me. Every fall I get insomnia, some years are worse than others. Most years I don't need anything, every couple years though... I take half a xanax and go to sleep for a few weeks... and I'm done. I should "probably" take it during milder years, to shrink it from 3-4 months to 3-4 weeks... but I don't. It just doesn't occur to me until after the fact. Oh, yeah.... Drats.
___________________
Benzos v SSRIs
The great thing about Benzos is that they work right away
The great thing about SSRIs is that they aren't addictive so can be used long term.
In general, benzos are Rx'd for short term use, and SSRIs for long term use.
____________________
The above are JUST MY side effects. SSRI's just to sleep. Yep. Works great. The only problem is that they take time to work. Certain benzos work as well, but are instantaneous, so I prefer them. I don't need them longterm, so it's a nonissue. If I had insomnia long term, I'd stick with SSRI's.
The only way to find out what will work with YOUR system, is to try.