This one has it the other way around, and the star is Terence Hill:
Super Fuzz (1980) Also in the cast are Ernest Borgnine, Joanne Dru and Marc Lawrence. / From IMDb: Red powder from a nuclear explosion gives a police officer superpowers as long as he doesn't see anything red. He is eventually framed for murder and is unsuccessfully executed by many different methods. From IMDb2: Policeman Dave Speed is assigned to a mission in a former Native American reservation near a military shooting range. Dave is doing an investigation when a nuclear missile explodes. The radiation gives him superpowers, including moving objects with his mind and leaping from skyscrapers.