Northern Ireland’s second largest city is as much a frame of mind as it is an identity — with a shared culture and mutual pride of place, writes Kate Ryan