I contend that the consensus is simply that CO2 is a greenhouse gas, and that doubling it's level will cause some warming.
The level of warming, weather the warming would be good or bad, ect, are not included in the consensus statement.
If properly stated even Cook's 97% is not accurate unless qualified,with the full statement.
Quantifying the consensus on anthropogenic global warming in the scientific literature - IOPscience
So the 97% is only among papers expressing a position on AGW, excluding 66.4 % of the papers who did not express a position.
And in qualifying the consensus here is what they said,
Humans are causing global warming! how much 5% 50%, 97%?
My point is that people attribute much more to the 97% than is actually there.
For the record, if the assumptions made by the IPCC are correct and 2X CO2 will force 1.2 C of warming,
then the warming from the increase in CO2 would be 1.73 X ln(406/280)=.642 C, more than half of the observed warming.
It does appear that Human activity is causing some warming, but the system is so complex, that we do not know
how much it would have warmed(or cooled) without the added CO2.
What we can measure, is coming in lower than expected.