>Anyone mind giving me a TL;DR on the value proposition/use case of Notion?

There isn't one.

Notion blasted the Youtube Selfhelp/Productivity space with sponsored videos to get a buzz going and now are moving to continue their growth story by offering a free tier.

It's designed to convert your productivity into minuscule parts to convince you that you are achieving goals. Akin to playing a game.