In the False Prophets adventure, publishedin the back of Black Crusade there is an optional objective for certain characters to recover samples of flesh from the crew of a wrecked starship that's now a chaos temple. This material has been preserved for years and a follower of Nurgle wants it.
The scenario resolves this little objective by way of a series of rolls: sneak past some guards, get into the preservatory, the usual stuff. In fact this is how much of the adventure (bar the shooting) is resolved. It's not terribly inspired and of course suffers from what happens if those rolls go wrong (the temple guards kick your ass). So how to make this more exciting, particularly if the character in question isn't Sam Fisher or Agent 47?

Maybe create a Failure Roll Chart of some sorts that has a spectrum of elements of failure rather than the binary pass/fail of the written adventure?

Or use the degree of failure as indicator of how badly the guards react to the failed roll?