[felix]

I know the trend is to correct many things in post, but there are times that can't be done or has other limitations.

 

 

I found that out the hard way while trying to digitize color film negatives. Without a filter, it's very easy to blow out the red channel or completely underexpose the blue and green channels. I now use a B+W KB-12 (blue) filter to partially compensate the orange mask. 

 

Regarding your aquarium light: If you're an Adobe user, you could try to add a custom camera profile with a skewed white balance using the DNG profile editor. I have such a profile for my infrared images (>720nm), because the normal range of white balance adjustments is not enough to get rid of the red cast in the images. Dunno if it works, though. And it obviously doesn't help at all for video 

 

Ultimately, I think it's only in such extreme situations that color filters are still useful in digital photography. Most of the time one can correct things in post.