Is there much of a pay-off (because of the narrow nature) on trails, especially regarding grip and general durability? I’m talking more about rooty/rocky/roll-in stuff as opposed to swoopy singletrack
Short answer – yes – massive compromise. You appear to be heading towards one extreme of the scale.
Better answer – yes – but does it matter to you? You may be light enough/skilled enough to cope with this compromise. Depends what you want most and what terrain you ride over most frequently.
Compound obviously has a big impact too.
Personally, I tend towards the other end of the scale, ‘cos time spent fixing pinch flats ain’t making me any faster.