The development speed with ORM's is ridiculous fast and easy on the mind. I do agree that for large, complex performant queries, ORMs might not work out, but I

The development speed with ORM's is ridiculous fast and easy on the mind. I do agree that for large, complex performant queries, ORMs might not work out, but I would say that those queries are better written as SQL procedures / functions because they are bound to be modified or changed anyway. Having said that, most LOB apps, small apps, apps that have in-frequent access of the DB, etc, can benefit from using ORMs.