City referred to as 'Satan's layby' crowned UK's most underrated