Do I need creative Cloud to use Font Folio or does it work with CS6?

The Adobe Font Folio has absolutely nothing to do with the Adobe Creative Cloud offering. I think you are thinking about TypeKit which is included with the Adobe Creative cloud, integrates with the Creative Cloud applications, but also allows use of the fonts therein with other applications.

The Adobe Font Folio is a disk with pretty much the entire Adobe Type Library. You install any number of fonts on the disk onto your system and they act just like any other fonts with any applications, including the CS6 applications.

          - Dov