I'm pretty sure it's an immunity to the harmful effects, not the helpful ones. I only say "pretty sure" because I've never done any hands-on testing with it. But I do know that all spells have a "hostile" flag, meaning if it's set, then it's considered a harmful spell, and NWN makes several decisions based on that.
Harmful effects... so will it prevent beer goggles?