I'm going to go with option C with the following reasoning:
I'm going to assigned (somewhat arbitrarily) the following values to each outcome:

0 | 1 | 2 | 3 | 4 | 5 | 6

• | - | - | - | - | - | - -8 | -4 | -2 | -1 | +1 | +2 | +4

This codes failure outcomes as having a negative value and success outcomes as having a positive value, with the value doubling for each increase in success/failure. So, the expected value for the 4 options are:

A: -12 B: -6 C: -3 D: -6

Meaning all of the options are bad, but the least bad is option C. And this makes some intuitive sense. You have an equal chance of success or failure and while no success will be all that spectacular, you will also never suffer a spectacular failure. Die A seems like an interesting choice, but you would expect to suffer a catastrophic failure about half the time and that may end your ability to keep rolling. Die B is a slightly less bad version of die A, and may be an ok choice, if a 1 result doesn't result in you no longer being allowed to roll. Though, if you are not able to stop rolling whenever you want, a 5 outcome is likely to be wiped out fairly soon. Die D is just straight out bad. It always results in a failure; so, there is no point playing.