Few geographical areas have had the same outsize impact on popular culture and artistic imaginations as this small region, framed by Scotland, Wales, the North Sea and a hotly contested southern border.