I intend to mod my DSLR in future but I am in no rush. The prospect of having modded DSLR camera that can produce some breath taking DSO images is any amateur astrophotographers dream (mine anyway...).
I've seen some amazing images taken with and without a modded DSLR and know the difference a modded camera can make. But at the moment I am quite happy if my Tarantula's are green.
If I was going to get serious about astrophotgraphy, I would do what Paul suggested and get two DSLR cameras. One for general daytime use and one for Astrophotography. That way you don't have to worry of colour balance etc.
I guess I am lucky that I haven't caught the modded DSLR camera fever yet.