I remeber reading some article a few years back in which some economist measured the amount of happiness people had in their life and put a money value of it per year. If I remeber correctly, living spiritual \ religious life came in third place after having a good spouse and having a good family.
Maybe it's because of my choice of friends, but in my experience, most people I know who turn religious were not at all happy but tried to convince everyone they were.