The spreadsheet user is the deciding factor
Hex and Sigma are both warehouse-native and both promise more flexible analysis than a static dashboard. They get compared because a data team that wants to give the business more freedom has to decide whose freedom that means. Sigma extends it to spreadsheet users. Hex extends it to people who code. The tool that suits your organization depends mostly on which of those groups is waiting longest today.