How do I handle always being the one who delivers bad news?
You can take any messy question and give it a rigorous answer. And often that answer is the one nobody wanted: the effect is not real, the results are not significant, the hope does not hold. Being the person who keeps saying no when everyone wants a yes is a lonely post. Over time it can make you feel like a wet blanket instead of the honest expert you are. But look at what you are actually protecting. Every time you say the results are not significant, you save someone from betting on a mirage. That is not negativity. That is care. You are the one keeping the whole enterprise honest, and honesty is a gift even when it does not feel like one to the person receiving it. To keep from being worn down, change how you frame it, for them and for yourself. You are not the bearer of bad news; you are the guard against costly mistakes. Say the hard truth, then point to what it does make possible, the better question, the wiser bet. And remember that being trusted to tell the truth is a rare kind of respect. Carry it with some pride.