As someone who thought people fainted from anything because of books, I can relate, and I put it everywhere in my stories. Turns out, real life faiting is way less dramatic or fun, and just taking a whiff of chloroform isn't going to send you 3 hours into the future.
Nowadays, I still end up using it every now and then, but there's always a reason. The character was knocked out so they'd get captured, or they used too much of their power and the body forces rest then and there, or someone cast a forced sleep spell, that kind of thing. Probably goes without saying it shouldn't be used to show a woman being fragile, but also, it's better used in a fantasy setting where magic can make it happen without giving the person horrible side effects.
It's a neat trick to change chapters or locations very quickly IF you can place it properly, but you can get away with cutting using a perfectly conscious character if there's no immediate consequences to all that time you compressed.