(disclaimer: I joined supabase 3 months ago)
I've been using it for 2 years for everything I've built and the experience is amazing. I always recommend it. As a frontend dev coming from Firebase and other BaaS tools I had to learn some SQL and RLS first but once I started getting the hang of it I couldn't use anything else, it's just too good.
Best part is being able to use the parts of supabase that I need instead of opting in to a whole BaaS. I have some APIs that only use the database. I have an app that only uses storage (like a google drive for me). It integrates with many other tools, (nocode tools, ORMs, BI tools...)