Me! Mine was a huge lower molar with massive curved roots, and should have been a "simple extraction" but ended up having to be sectioned into pieces because it wouldn't come out. It was still done under local, by my own dentist, but that was possibly because she started out thinking it was one thing and it ended up being another.
Honestly, I found it a bit traumatic, and had to ask for a break in the middle, but there was absolutely NO pain. The dental nurse actually held my hand towards the end, with her other hand holding the suction thing in my mouth. At the time, it seemed like it took forever, but it was less than 30 minutes between sitting down in the chair and leaving the building.
My appointment was 10.30 on a Friday morning, and afterwards I felt a wee bit shaky, but I had the hairdresser at 1, and went to that fine, then was out for dinner on the Saturday night. I had to go back the following Friday to make sure all was okay, and my dentist was pleased with how it had healed over.
I should also say here that my situation was possibly a bit weird, which is why I found the process traumatic. I'd been clenching and grinding my teeth through stress, but didn't actually realise until I cracked the filling that was in that tooth, causing terrible pain. My dentist re-filled it, it didn't settle, then she did a root canal, but couldn't locate all the canals. I could have been referred on to a root canal specialist, but by then I'd had months of pain and appointments, and just wanted the tooth out. (If it had been a further forward tooth I would have persevered.)
My best advice would be (1) eat something first if you can - I didn't because I was nervous, and in retrospect that probably contributed to feeling shaky. Also you won't be able to eat for a wee while after until the numbing wears off. (2) make sure you have something nice planned for later. I ended up needing a load of work done over a short period because I had knackered several teeth with grinding, and always had a treat after each appointment - sometimes buying myself a bunch of flowers on the way home, sometimes knowing DP was cooking a nice dinner for later, sometimes ordering something online that would be waiting when I got in.