I think the Cabot Trail is beautiful. I understand why people head there and take it in.
There are other parts of Cape Breton to see and drive, and if you like driving, I recommend the Fleur-de-lis Trail. Whenever I am driving from Halifax to Glace Bay, Cape Breton, I make sure I get off the Transcanada Highway and go along that “old highway” instead. The scenery is gorgeous, and the road is fun to drive. You know all those car commercials on TV where people are driving on highways and you think, “yeah, sure, there’s no place like that for real people to drive along”. Well, if you go along the Fleur-de-lis Trail, you can.
(Bonus, it used to be mostly a 2 lane highway, but now it is more and and more a 3 lane highway, meaning you never get stuck for long behind slow drivers if you want to drive faster. Though with all that scenery, why drive too fast?)
(This wonderful autumn photo of Cape Breton is from paellaking’s photostream on flickr. Seriously, this is the way most of the trail is, when you aren’t driving by fantastic lakes).