Although Sydney is the center of Cape Breton, it lacks major tourist sites itself. A couple of things to see are:
Two private homes dating to the earliest settlement of the city, Jost House and Cossitt House, remain in the downtown area of Sydney.
The recently revived Wentworth Park, a 5 minute walk south from the downtown core, is worth a visit.