Just remember that with read committed isolation, certain access patterns can silently trash your data.

People are afraid of transactions aborting for some reason, as they think that's an error. It's not; you just retry your transaction, which will now be using correct data. "Read committed" opens you up to race conditions in exchange for transactions rarely (never?) aborting themselves.

I think the default should be "never trash my data without telling me".