Did 9-11 prove prayer doesn't work, or that god is a cruel psychopath?

Yes. Unfortunately, I believe this tragedy painfully illustrates strongly that god doesn't interact in the world or answers prayers.