You can’t get more at the heart of Bamburgh than the aptly-named Middle Inn.