Some of the world’s most glorious sights can only be experienced if you crane your neck. Jonathan Glancey looks up.