It all depends on what your goal is.
In health care applications? In financial applications? I would never trust anything less than fully acid with all the bells and whistles.
In a website where people aren't going to be that bothered of a few transactions are inconsistent if some major snafu happens? (status updates get lost in the ether, for example.) The cost isn't worth the benefit of high power.
RDMS is a similar tradeoff.