Here is a set of Photoshop actions which can be used to fuck up normal maps so they can be used in SC2.
You may also wish to review the Modelling and Exporting for SC2 thread. I am posting this separately here as to make it easier for people to find the actions.
Generate a red SC2 normal map from a standard normal map
Increase the values of the normal map so it is actually noticeable ingame