The tall buildings in the upper-right corner of the picture are on Russian Hill, more than a mile east of where I was standing in Cow Hollow. Yet they seem to rise up and loom over the houses close to me.
Because it's built on hills, San Francisco is full of view like this. About four years ago, standing in about the same spot, I looked north and saw an ocean liner on the Bay seeming to loom over the houses down the hill from me.
Trying to understand what makes view like this so uncanny, I found an article on the psychology of perception. It seems we have several ways of understanding the sizes of objects.
For instance, if I'm standing close to a house, it fills most of my visual field, so it looks big. If I stand far from it, it fill less of my visual field so it looks smaller, but I know the house is the same size as it was, so I correct for that mentally.
But when I know a distant object (tall building) is bigger than closer objects (houses), and closer objects are going down hill, and distant objects are going uphill, I have a lot more mental correcting to do. So, I guess, that makes the view more fun to look at.
Fortunately we do all this without having to think about it.