Stupid Wii power supplies, these are known to be pieces of junk. I keep a spare for this reason. Simply letting it "rest" unconnected for some unknown duration also does the trick.
I heard it as the Wii power supplies are very protective against surges at the cost of being extremely sensitive to surges. I've done the "unplug it completely for a few minutes" to restore functionality a few times.