To put it in context, a VW Golf Combi or Peugeot 308 SW have 10+% more cargo space in a package that's slightly longer and narrower than equivalent CUVs like Skoda Karoq or Peugeot 3008 (2 of the roomiest CUVs out there). Whether you find width to be a bigger problem than length when navigating depends on where you live and how you drive. But the choice combi vs. CUV mostly comes mostly to image.
As you can see the Karoq offers marginally more space only with the seats folded. But that to me feels like an exceptional usage scenario rather than the rule. With the seats up the difference is pretty massive (the SW has ~30% more cargo space) and I think this is the more useful number if you're interested in cargo space. If you want a higher driving position, or better ground clearance, etc. a SW won't really do it.