Midazolam isn’t great for sleep induction, the duration of action is extremely short, the window of sedation may not be long enough for one to actually fall asleep… I’ve found Oxazepam to be the most efficacious for sleep induction.
Temazepam/diazepam was associated (for ME) a hangover/feeling groggy the next day. I don’t use benzodiazepines to elicit sleep anymore, but when I did use wasn’t continual. I’ve found (with a prescription) using 1-2x/week max can offset the development of dependence.
Etizolam also works as a short/intermediate acting sedative, it’s a thienodiazepine. Z-drugs like zopiclon have been associated with acute psychosis post intake. Benzodiazepines can also induce paradoxical reactions, however the psychosis/“ambien zombie” effects noted with Z-drugs are unique to imidazopryidines, pyrazolopyrmidines and cyclopyrrolones.
Cannabis can also work as a sedative, however the substance is illigal, is associated (for some) with feeling groggy the next day, adversely affects cognition following continual use and entails the act of smoking.
Gamma Hydroxybutyric Acid (Xyrem) depending on how it is used can act as a short acting sedative, but carries with it all of the problems associated with benzodiazepine use and has significant recreational appeal to boot.