As Dan MacCarthy dips into a new series of guides on the country’s best walking spots, he discovers that size really doesn’t matter when it comes to the breathtaking beauty on offer