Took the family there last August and it certainly wasn't overrun with tourists (or tour-asses for that matter). Camping was very spacious, roads not busy at all by Ontario standards. We loved it! Went to Louisburg, the Gaelic College, and saw lots of natural beauty. We hope to return.
One observation: Our favourite Ontario destination is now advertising on TV, and we selfishly wish it wouldn't because there are already too many people (those tour-asses) littering, loitering, polluting, and crowding the place. It has got to the point where many residents go elsewhere for long weekends to avoid the rowdyism. Tourism may save their municipal pocketbook but will damage the natural beauty. There is no solution as I see it, people have the right to visit, I just wish they'd tread more softly you know...take only pictures, leave only footprints. Hopefully Cape Breton, unlike our corner of Ontario, can find a balance.