> And with good ORMs like Entity Framework the underlying queries they generate are predictable.

Right up until they are not and generate crap. I went from "predictable" EF generated queries to handcrafted ones reduced the load on the DB by about 70% while having more queries per second...