No, I've never had sleeping pills per se. But a particular anti-depressant I was once prescribed sent me straight to sleep. I couldn't even keep my eyes open during the day. It was a terrible experience.
Codeine knocks me out, so I have taken flu tablets, panadine, nurofen plus etc.
Also phenergan (that allergy tablet), before I knew it knocked me out I was taking it for hay fever and wondering why I couldn't stay awake through the day.
Also got given a box of these relaxation drinks (opposite to red bull) and two of them gets you snoozing!
I don't think it is a good idea to rely on these measures to sleep. There are other methods if one is having regular trouble with sleeping. Exercise during the day, cut out caffeine after certain hours etc.
I think too many people abuse these medications and see them as an easy alternative while not thinking about their long term health.
I usually sleep quite well so don't need to take medication. Occasionally I have a warm milk drink to help me relax. Once I was in hospital and was offered sleeping tablets but refused. Another patient in my ward was quite noisy during the night which made it so hard to sleep. I wondered if I should have accepted sleeping medication.
I do when travelling against significant time zones. I set my watch to the destination timezone when I get on the plane, and then take a sleeping tablet .... and usually wake up at the other end, and my body and mind is aligned with the destination