SIPs look great when vertical — or nearly so.
Do they do anything special on a flat roof? It’d be a rooftop deck, eventually.
My inclination is to frame and sheath, then spray foam on the underside, but leaving these 100 year old exposed beams appeals to me, as well.