You get 24hr duty pay, that's it.
As for not liking your wife, you have to think a bit wider than that, for instance, alot of pilots spend alot of time on motorways commuting to work, so nightstops are a better option than spending 3 hours a day sat watching white lines, lorries and trees. Another reason is alot of pilots have been displaced from a closed base, this means they are paying accommodation to be at their current base, if the company nightstops them then they won't incur the costs; they're away from home anyway, so they may as well nightstop.