The types you ask for are quite rare. If you accept human nature for what it is, you have to admit the possibility that claims are being exaggerated for political opportunism, fame, grant money, clicks ... and due to the huge cost of all proposed solutions, you'd want to double check. But if you ever double check any of this stuff you're doomed because environmental research is so riven with fraud. You end up a skeptic and be immediately excluded from politics, media, and academia. That's why you can't find many of that school of thought.
As for the "naive pipe dreams" as you put it, I suppose being more pessimistic will soon lead you being labelled as a doomer and ignored. There is some material though, like Uninhabitable Earth by David Wallace-Wells. It's a depressing read.