I guess you might say that large scale public artworks might relate to that same human impulse to create something aesthetic on a large scale (say, The Kelpies, Northumberlandia) but the cultural significance or importance is probably quite a different thing as most public art is both secular and generally functionless other than as art.

I also suppose you might say that public places of worship, from gothic cathedrals through to modern mosques also have some elements of affinity or connection with the megalith makers. It's difficult to know whether prehistoric monuments were viewed in purely functional terms, but I doubt as many are clearly designed to look aesthetically pleasing too. It's also clear to me that many are designed to be viewed as a feature within the context of their own very specific landscapes.

Just as a cathedral has aesthetic appeal in its own right while nevertheless having worship and religion as its primary function, so might a prehistoric monument have both function and also, separate but intertwined, have a form which can be appreciated as aesthetic in itself.