You think that "97% consensus in climate science" comes from
Oreskes 2004, that you mentioned above. But this is not true. Indeed Oreskes asked the imprecise question about A attribution to Global Warming and found out that all 928 papers endorsed AGW, so Oreskes' number would be 100% and not 97%. I agree her methodology was somewhat flawed, so I would suggest to simply disregard her rather than forming our opinion on her imprecise methodology. Because, there exists other attribution studies, their methodology more precise, and they found the expert consensus number between 91% and 97%. Some of said studies are:
Cook 2013 which found 97.1% consensus from abstract review process, but more importantly, they invited authors to rate their own papers,. the consensus turned out to be 97.2%, confirming the level of consensus found from reading the abstracts.
Doran 2009 a survey of 3146 earth scientists with the question
"Do you think human activity is a significant contributing factor in changing mean global temperatures?". 82% overall responded yes. They also segregated their subjects into "non-climatologists" who didn't publish research (77% in that subgroup answered yes) and "climatologists" who actively publish research on climate change (97.5% in that subgroup answered yes).
Anderegg 2010 surveys all climate scientists who have publicly signed declarations supporting or rejecting the consensus. They found 97% to 98% of these experts support consensus. But further, they looked at number of publications and h-index in both groups. And they found that within the large group of "converted", the number of publications (as well as h-index) is twice higher than in the group 2-3% "skeptic" group.
So, firstly 97% consensus number comes from the studies I cited above and not from Oreskes 2004 as you mistakenly believed,
Secondly, last two studies confirm that the higher expertise level opinion we seek, the higher consensus level we get, with marginal "skeptics" showing less expertise than their "converted" colleagues. A data trend that'as hard to argue with. Maybe yourself, who do not believe in said consensus, think about 82% overall scientists in Doran 2009 who responded yes. But this is not an "expert consensus" because it necessarily includes earth scientists who have no knowledge about climate (e.g. petroleum geologists).
Finally, the conclusion that humans have caused "most of the global surface warming over the past half century" (i.e. A contribution is more than Natural contribution to GW), was stated in
the 2013 IPCC report with 95% confidence. IPCC is very conservative organisation and will not issue such statement if there is no evidence for it. We can compare that IPCC 95% number to 97% expert consensus number from the above studies and say they are in agreement.
In summary, as much as I would like to agree with you BB (because I like you & because if there were no consensus among experts we would have a better chance of finding a "getaway" from increasing AGW crisis) I just cannot do that as available data tells otherwise.