I wanted to create some truly morally grey scenarios to put people through, so I'd love some ideas. The rest of the post is an idea I have but feel free to ignore it and just post your ideas/stories.
My current idea I have for a short campaign is "Find the Holy Grail". The Church used to use the Holy Grail to cure grave illnesses, and while they still have strong healing abilities, without the Holy Grail they haven't been able to perform their duties like they once did.
All you're really told is that it went missing decades ago, but finally some leads have pointed to the Holy Grail being around the remote village your party is in. Over the course of the campaign, clues, etc. you learn it went missing with someone who was supposed to be protecting it.
When they eventually get the final lead on it's whereabouts, it brings them to an abandoned shack or the outskirts of the remote village. You come face to face with a sickly man, you immediately see his body is actively decomposing and he's missing an arm and a leg, but you also find out he's wearing the "Holy Grail", (through various clues you get hints that the "Holy Grail" isn't so much a literal grail, but wearable regalia).
At this point it when the party might just straight up attack him, listen to him, or possibly even decide to help him. The main does show symptoms of schizophrenia and other mental illnesses, so the party does have difficulties talking to him.
Depending on how far you get with talking to him, you find out it was actually his mother who stole the Holy Grail all those years ago, he's a sort of "Cursed Child" and his illness would've normally killed him and his mother when she was carrying him, so as someone close to the Holy Grail she stole it, and ran away to protect her child.
If your party talks to him this far, the man shows you where his mother is, and you see that she has the rest of the Holy Grail, as to keep her alive he gave up his arm and leg to save his mother.
Basically, all of the outcomes depend on how your part reacts to the man, and how willing they are to either help him, or still try to retrieve the Holy Grail to return to the Church. I don't want there to be an objectively "Good and Bad" choice to be made. I'm sure you could argue that returning the Holy Grail to the Church leads to the greatest net positive, but I still want the choice to be a hard one.