Having read through the thread, it seems as if everyone is saying the same thing, albeit using slightly different prose:
Money vs Family - everyone would state family is the most important (and tbh, if it was the reverse, they'd be pretty daft to be posting on Mumsnet)
Money vs Health - everyone would state health is more important - money aint no use when you're gone.
But I don't think that the original question was "If you could have shitloads of money, but instead not feel the love of your children / DP and suffer some terrible illness, which would you choose?"
The answer to the above is bloody obvious.
The question that was asked is would money bring happiness?
If you are already suffering due to marital disharmony, the illness of a child, death of someone close, ill-health, no, money won't make you happy (although in some circumstances, it could help - my colleague just sent a stack of cash to her acquaintance living in Mongolia who would otherwise have died as a result of a stillbirth, no-access to medical care, being an outcast of her family, having married outside her tribe. That money will have brought her happiness (in the form of her life, plus the happiness that my colleague had in being able to share her wealth)).
But if you are living an ok life, as many of us are fortunate to do (relatively good health, happy kids, ok marriage, roof over your heads, food to fill your belly) then having an extra million chucked your way on top would still be most certainly welcomed by the majority of people, I would think. And if they don't want it, they can chuck it my way.
I'd be bloody happy with more cash.