>might slow down a very slightly different query by 100x.

Again, any optimization needs testing and QA. But in general shouldn't things like pinning keep the plan to a single query type?

Also 99% of what?

If you have a query that runs once a day, but takes a very long time to run, a 10x improvement is huge.