Just depends on the context... for oltp production environments, might not be so great in a lot of cases. However if you have users building up dynamic queries

Just depends on the context... for oltp production environments, might not be so great in a lot of cases. However if you have users building up dynamic queries, etc it might be really nice to fail gracefully if they go overboard, or if there is some temporary condition that is preventing an optimal execution plan. Better than chewing up all of your resources in any case. I think this could be really helpful in test environments as well.