I love LINQ's syntax and monadic API, but that's about it.

It speed-runs juniors into thinking they are writing transactional code when they aren't.

And for seniors who are more aware of footguns and try to be careful, they're met with an inability to do so (e.g. upserts).