Honest answer coming up.
I've had a few out. There were a couple that did not hurt at all, they were just in the way, not infected or anything.
Another that didn't hurt, which had come to the end of its useful life - thatw as also fine. No pain, just some pulling.
There was one other which was not painful at all but it did break when it was being taken out, so they had to cut the gum slightly to remove the other bits - not pleasant, but I wasn't in pain, just anxious iyswim.
The last one I had out was very infected as the root had cracked and it had within a few days become unbearable. There was no point waiting for antibiotics to work because it was in too bad a state, so I had it out without them. Because of the inflammation the anaesthetic didn't work, and I felt the entire thing. It took about 10 minutes to pull out and it was incredibly painful.
However the thought of the relief afterwards and knowing there was no alternative got me through it and I did get a sticker
Basically, when a tooth is grumbling you are best getting it out then rather than waiting till it is full on painful. You should have no problems with the anaesthetic, from what you are saying.
Btw codeine isn't that effective for dental pain and makes some people sick so I don't use it. What worked for me for a couple of days before the extraction was something called Naproxen, which is fairly hardcore but without side effects as far as I could tell, and just took the pain away completely - I could have stayed on that for weeks and not known if my head was falling off tbh. Which is why you have to watch it - it can 'mask problems that need attention'
good luck don't worry, have shared the best and worst case so you can see where you are likely to be on the spectrum of pain and it looks like right near the good end, to me