[digitallogic]

Depends on the context of the application.

Social networking web sites? Yes. Video games? Definitely.

Business applications (or anything dealing w/money)? You sure had better fail and roll back any transactions.

But I think your point stands when you consider that the cases where it's ok to keep going after something wrong happens are the exception, and not the rule (most software is automating boring business practices).