There's the lightning rod we haven't seen for a few months around here!
It's like just about any other financial product; if purchased for the right reasons, from the right company, in the correct scenario, it can be a good thing to have in the portfolio. If bought for the wrong reasons, from the wrong company, in the wrong scenario, it can still have it's benefits, but your money will likely do better elsewhere.
If a person is in a relatively high tax bracket, has maxed out his other retirement buckets, and/or has a long term need on the insurance (like FinMick's example of special needs trust or Nac's example of estate planning) it can absolutely be a fantastic product.
The problem is too many guys in the insurance industry (Northwestern included) sell it to people that have no business buying it, or buy it before they should buy other things. I'm not saying that's happened to the OP, because he did say he's maxed his 401K and 457, but asking a few more questions of the adviser wouldn't be a bad thing. It may be perfectly appropriate for him to recommend it, or he may be trying to sell you something you don't need.....there's honestly not enough info in the OP to be able to tell clearly.
@FinMick, regarding the company keeping the cash value, one thing to keep in mind is that on most permanent life insurance policies (Universal life, whole life, variable life, etc) the death benefit grows over time. Very often, the growth in death benefit outpaces the amount of cash value in the policy for a number of years, meaning that if the insured dies, their heirs would receive a larger amount of insurance than they first purchased....often that larger amount exceeds the original benefit plus the cash value. Just food for thought. Otherwise, what FinMick said is pretty much spot on.
Personally, I don't care what percentage of income a firm makes on a certain product line. Some firms might have more of a niche market, or focus on one area of planning or sales over another....doesn't necessarily mean they're always wrong with selling a client something or recommending one thing over another; I think that's more of an adviser-to-adviser question. If I'm talking to a car salesman I know he's going to try to sell me a car. I expect him to get paid on it....I honestly don't care if they make more money at that particular dealership off of new cars, or used cars, or servicing, leasing to fleets, etc.
[This message has been edited by Stive (edited 6/20/2014 10:46a).]