Am I missing something, or is there no way to group swatches/tidy them into folders in the CS6 Indesign swatch palette?
You're not missing anything. That's not a feature of InDesign's Swatches panel. You could let the InDesign product manager know you'd like this by filing a feature request:
Adobe - Feature Request/Bug Report Form
Retrieving data ...