I just re-read Dune, and wouldn't say that is entirely accurate. There are multiple times that Mauddib sees terrible things in the future - jihads, death, loss. There is a terribly dark foreboding sense from these visions, but I get the sense that the terribleness is from Paul's actions/status as well as that of their enemy.

Spoilers inside.

I got the impression that Paul saw many possible futures where there was certainty of a bad outcome, and some possible futures with an unknown outcome, and that the path to the unknown outcomes all involved jihad and death. So, at least in the first novel, Paul felt compelled to pursue jihad in order to provide an uncertain future, as avoiding jihad would be worse.

It's been quite some time since I read beyond the first novel though.

Paul foresaw the Golden Path, but I don't think that was until after the jihad in the second book. That's why he went off to the desert isn't it? He took the path and was trapped by it.

Still spoilers.

My interpretation is that Paul didn’t take the golden path. He felt trapped into taking it, but when twins were born, he was freed of that obligation because it opened up a future he hadn’t foreseen.

I think you're right, he knew there was one but didn't peer into it for fear of being trapped by it. Seeing the future makes it absolute in Dune, hence Leto's bloodline development program with Siona.

I understand the terribleness of Paul's status derives from perfect future knowledge destroying his hope.

Imagine looking into your child's face and knowing the exact time and nature of his/her death. I think this is a big reason childhood diseases have the status of especially evil.