To be precise, he gives 25 happiness immediately and more later. So it COULD be worth it, but usually you don't want to.
Oh really?
Cause personally he gave me happiness once I think and then he almost immediately asks for more money.
In my experience, he keeps giving happiness at the phase after the questions are asked each day but before the stats are showed.