The scenic Snake Pass connecting Sheffield and Manchester has been named as one of the most romantic driving routes in the UK.