That's both its biggest advantage and disadvantage. It's an advantage in that it can be stretched and flexed to cover any problem domain, by rigging up a language suited to the domain. On the other hand, the fact that it's so flexible means there's less common points of reference for composition in the large. Learning a language for a domain is usually more work than learning a library that uses familiar idioms, even if it is more flexible in the long term. If that domain isn't your bread and butter, a library suits you better.
It comes down to an economic argument, I believe. Some level of centralization is necessary to overcome the transaction costs of fitting lots of little languages together, which each have their own ideas about how things should work. It helps hugely in tooling, debugging, analysis, etc. Syntactic transformation via macros from a high-level language to a lower level isn't enough to create a practical modern language in the large. You need more.
As to the practical applicability of Lisp, I think you can get most of what you need with something like Clojure.
EDIT: HN is written in Arc. You're saying that there's "little you can usefully do with LISP" on a site which was written in lisp.
What I said was that it's not user features that keep people here. But there is more to the software than user features. A good example is the code that protects against various kinds of abuse, like spam, trolls, and voting rings. By LOC that is a large percentage of the total, and HN as a community would be long since dead without it.