Thanks for the response Vaclav,
Much of the insight reaffirms what I suspected about Revit’s capacity for data versus the current state of practice, and the challenges that have to be overcome.
As for our own carbon database: That side of the problem is solved in my case
We have a workbook setup that is a curated collection, largely based on the ICE v3 database (commonly used in the UK)