Are people happy with Notion? We didn't renew our (extremely expensive) subscription. The product is clunky and slow. As a team, we never needed the collaboration features. In the rare case where we do need some real-time shared writing space (mostly just for taking notes during Zoom meetings), we make an O365 document.
As individuals, a lot of us have moved to Obsidian, but we aren't using it collaboratively. Personally I just use it as a simple note taking space; I keep a note for everything I've googled multiple times, and I can pull it up quickly with a simple cmd+p or cmd+shift+f. Notion provides basicallly the opposite experience (open a website, wait for it to load, use their shoddy search, wait for that to load, then maybe find what you're looking for).
As a team, we don't feel like we're missing anything without Notion. We collaborate in markdown using GitLab pull requests and Mattermost chat messages. Some of us write that content in Obsidian and then paste it into the GitLab text input (have you ever tried pasting markdown into Notion? Good luck with that!)
I think some non-devs might prefer Notion, but as a dev, the idea of using some proprietary React frontend as a note taking tool is the opposite of what I want. Obsidian is great.
IMO Notion got distracted with this "database" idea, where everything is a "block," because the reality of it is that the experience of everyday text editing becomes infuriating. Nothing will make me resent a product like unintuitive shortcuts that hijack my return key and closing backticks (also see: ClickUp).