https://www.novascotia.com/explore backgrounds this picture.
Even if I'm right to guess Cabot Trail, where exactly is this?
Can I drive up to this lookout? Any hiking required?
Per this page also from Tourism Nova Scotia, the image appears to be taken on Franey Trail, Cape Breton Highlands National Park.
The Parks Canada site describes the trail as a "difficult" 7.4 km loop accessible only on foot:
You climb up and up and your reward is at the top! Large flat rocks give you a nice place to sit and enjoy the 360º views of the entire Clyburn Brook canyon and the Atlantic coastline from Cape Smokey to Ingonish. Gaze back at the mountains, the sheer rocky face of Franey Mountain, or the river winding through the valley, 425 m below. Keep an eye out for wildlife – moose like this habitat too.
I'd also venture a guess that the image was taken with a drone, so your view from the ground is probably not going to be quite as nice.