Modern EF Core can generate SQL very close to handwritten and will aggressively warn you if you do something dumb. I wouldn't worry about it.
For the complex ones we like to have full control as it almost always turns into a major ops issue if the queries are not performing well.
Though perhaps if we can catch changes of the generated queries in our test suite we could let EF generate them. Trust but verify kinda deal.