Yes, I reckon it's an essential part of training for anyone who might be flying in conditions that could lead to disorientation (which is anyone really when it comes down to it, not just NVFR or IFR) - the ability, on realising something's not right, to get on the instruments, recover from an unusual attitude if you're in one, and establish safe flight, be it a level turn, a climb, or whatever's needed.
Also, respect for how quickly things can go wrong needs to be drummed in, and the need for some kind of plan of action, escape route, safe heading, safety heights etc etc - simple self preservation when you're used to thinking about those things, but a real trap if you're not.
Understanding and having strategies for coping with illusions is also a must.
There's a reasonable argument that a 'some' instrument training gives pilots a false sense of security, but if it's accompanied by emphasis on good airmanship (or HUF / risk management in the new speak) and not letting yourself get sucked into bad situations, I think the benefits are clear.