You don’t need a famous lakeside postcode to find a dramatic view. An Avis ranking points towards Scottish ruins, a submerged Italian village and a…