The magician spent years campaigning against fraudulent psychics, even lobbying Congress to ban fortune-telling in D.C.