I've had to use it to sedate my DD prior to having a tooth removed at the dentist. It was the only way we could have her "calm" enough for the dentist to inject the local anesthetic.

It didn't "knock" her out just calmed her down. She was also given it in hospital years ago for sedation prior to a ct scan, as it's more complicated to be working with general anesthetics for her diabetes then simply calming her down a bit and getting the tests done.

I'd never use it just for the sake of it, I prefer to look at other alternatives first.