I would say for wisdom teeth......definitely get gassed. I did, it didn't make it feel any better later but at least I wasn't there for all the tuggin' and pryin'
For regular visits, maybe a leftover Tylenol w/codeine, valium, or some other painkiller from the medicine chest. Nothing to knock you out but just a relaxer.
Good Luck.