Visitors often pass through this unsung corner to reach the big hitters of Pembrokeshire and the Brecon Beacons; but every bend contains historic treasures, enthralling vistas and untold stories, finds Jade Braham