I thought Freebase [1] was the most promising "Semantic Web" technology, with a powerful query language (MQL) and an application platform called Acre [2]. I'm biased because I worked at Danny Hillis' adjacent company, Applied Minds, and met with the Freebase folks to talk about graph databases. I went to one of Freebase's Hack Days, and I could feel the energy around building applications on a semantically-aware global database.
Unfortunately, they got acquired by Google, and Freebase eventually shut down. Thinking back now, I wonder if there would have been a business model in hosting private data graphs to subsidize the open source data.
[1] - https://en.wikipedia.org/wiki/Freebase
[2] - https://opensource.googleblog.com/2010/08/acre-open-source-p...