For Dragon Age, generate the normal maps like you would normally, but make sure you save the .dds as a DXT5_NM the first time you save your normal map, which will put the colour channels in the correct sequence. If you need to edit the map manually after that (e.g to blur an area), save it as a standard DXT5 so that Photoshop doesn't rejigger the channels again. Hope this helps.