I believe The Scar by China Mieville checks all your boxes, if you like non-standard fantasy. It's also one of my favourite books.
Main character tries to save the world, or at least thinks she is, but fails miserably multiple times.
She needs a lot of help from the people around her.
She takes a hell of a lot of trauma and abuse, including an injury that is months healing.
Pain and suffering? Check and check.
If older stuff is okay by you, you may want to check out Candide by Voltaire. It's goes to show you that work does not have to be contemporary in order to be sidesplittingly hilarious as well.
I draws things. And I seem to be some sort of marine entity.The Lies Of Locke Lamora may fit. Fantasy heist novel.
"Doctor Who means never having to say you're kidding." - BocajThe Wheel Of Time. You'll have all the action and trauma and main characters being given grievous, unhealable injuries that you can stand.
edited 5th Dec '11 4:32:52 PM by NoirGrimoir
SPATULA, Supporters of Page Altering To Urgently Lead to Amelioration (supports not going through TRS for tweaks and minor improvements.)Seriously? Nobody has proposed A Song Of Ice And Fire yet? It hits every single point on this list, especially the one about the non-heroes who get used and discarded. I think about half the viewpoint characters fit that profile.
Hail Martin Septim!The Malazan Book Of The Fallen. Going by your list, it should be exactly what you're looking for, if you like Fantasy. There should be more than enough of pain, suffering, slaughter, trauma and characters in dire need of both medical and mental relief to suit your tastes.
Join us in our quest to play all RPG video games! Moving on to disc 2 of Grandia!

So! Looking for some good books to read, preferably action-ish ones, where the character is not superman or provided with plot armour.
I'm a sadistic person, so I want a protagonist that suffers, not just as an ending to the book. Someone who can and does get the snot beaten out of them. Somehow it makes them more believable. It also seems to cause weird, mutated maternal instincts to kick in so that I just want to whisk them away and feed them home cooking until they feel better.
Not sure what the associated tropes are, but looking for the following things to happen in the book, probably. Don't need all of them, but they're nice to have...
Main character gets wounded. . Extra points if they scream and flail around realistically from it. . Extra points if they have to actually take time recover from it. . Extra points if recovery time isn't simply covered by a blank page and a time skip.
[x] Main characer not really the hero to save the world. . Extra points if they're just helping said hero, who is not a point-of-view character . Points if they are used and disgarded along the way as a stepping stone.
[x] Cookie points if the main character has to get rescued by other people. . Extra points if they have to be rescued because what they did was stupid, and people point this out to them. And there are consequences.
[x] Traumatic Events . Extra points if they're not just plot background . Extra points if it makes sense (i.e. guilt for something that actually WAS their fault, not just QQ self blame) . Extra points if this genuinely affects their actions - like severe fear of water / closed spaces (even more so if they flip out due to it)
[x] First Aid (not Worst Aid) . Or Worst Aid, that sensibly fails.
[x] Pain and suffering.
I'll add other wants as they pop into my head.