Do you think there will ever be an American president who is mostly revered by a majority of the citizens in your lifetime?

No

Most presidents only have approal ratings barely moving above 50 percent.
And these days, most people are polarized and are not open minded enough to consider policies initiated by the opposing party.

Much of this can be blamed on the MSM.