We stayed at the Cabot Trail Campground near Baddeck last summer, off loaded the MINI, and did the Cabot Trail counter clock wise, by heading East.
There are competing opinions about which way is best but this way you get maximum views.
I don't think you want to spent the effort hauling your trailer over the Trail. That kind of exhilaration is the wrong kind. You'll have plenty just driving.
If you stay overnight at Cheticamp Merry's Motel, run by a nice Swiss lady, is inexpensive and very clean.