Isn't that essentially the plot of Spider-Man 2 though? I mean, he doesn't have a cold or anything (though I think he did in a similar story in the early comics), but all the weight of his personal problems lead him to lose control of his powers because of psychosomatic issues.