Viewing BigQuery data from your Sheet was a pretty nice addition, circa Jan 2019.

https://cloud.google.com/blog/products/g-suite/connecting-bi...

I'm inclined to agree with you on Docs though, there is a bunch of stuff that Notion does (really badly IMO) that Drive/Docs just can't do, and so people use Notion instead.

For example (in case any Google PMs are reading), folding bullets, easily embedding tables, embedding sub-docs, faster navigation/caching of folders in the web browser, and perhaps most important, a sensible way to build a wiki-type knowledge base, with "front pages" on each directory (like how Github handles README.md).

I can't imagine what additional features the overwhelming majority of people need out of a word processor or spreadsheet software.

The otherside of that coin is feature creep. Docs/sheets so their job fine, so aside from minor updates//fixes they don't need to substantially change; given their user based substantial redesigns should be their own product and if they prove to be substantially better then they can migrate away from the old docs/sheets

Erm, the explore tab in Sheets is pretty awesome for small businesses and people unfamiliar with Excel-like formula.

Not sure when that was released, though!

Table of Contents navigator was recently added, I think "Document Compare" is fairly new.