I'm a big fan of Notion and I'm thinking about creating a personal site.
As for pros, I guess that the nice minimalistic look of Notion and how easy it makes it to create and update a website are the main two benefits. It is also really cool to keep everything within the same tool you use for other things, as well as keep the expenses at a low cost (Super only costs $4/mo for one site).
However, I've personally found Notion websites to be quite slow and difficult to navigate. I fear it will also limit my self in the future as I try to add more customization and features. Furthermore, in the case you want to publish content (as I do), I've heard that it isn't really good in SEO optimization (as far as I know, you can't edit meta title and descriptions, create H4 and H5, etc).
What are your thoughts on this?