Be 100% honest. How bad is a C-section?

I have a high risk pregnancy, cerclage and GDM. I'm 29w and baby is currently breach. There is a very big chance she will come prematurely and a high chance of C-section. I'm terrified of a C-section, especially the pain because it's such a large incision.

So, be honest, how bad is a C-section? I read they only give Tylenol and ibuprofen afterwards. I had an appendectomy 2 years ago and was still in excruciating pain with morphine and a C-section is a way bigger incision that an appendectomy.