How good would knowing the truth be, if we were perfect enough to use it?

How irrational do we have to be before lying to ourselves is a good idea? And how irrational do we have to be before it really is a bad idea after all?

Possibly also featuring our old nemesis, the remote associates test.