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

Unlikely.
The extreme media focus on the POTUS guarantees that every flaw, foible and error will be almost instantly exposed to billions of people.
It is hard to revere someone who is fallible. Every human makes countless mistakes in a lifetime. Therefore the age of reverence is over.