Doesn't Hourman get Superman powers for an hour from the pills.
Hourman centers on a "brilliant yet troubled" pharmaceutical analyst who discovers that he can see glimpses of tragic events about to occur one hour into the future.
This sounds more like The Dead Zone then a decent comic adaption.