Having had a bunch of dental work done, sometimes it's not unreasonable - I had my wisdom teeth out and was given hydrocodone for afterward, but I was fortunate and didn't have any pain warranting it after.

Being given opiates for a root canal seems insane, though - if you have crippling pain _after_ a root canal, I think that means the dentist did something horribly wrong.