I’m a simple man, I do everything in markdown and then store it in repos in Github/gitlab. This gives me something that looks good, it’s easy to embed images, links and the like and it’s trivial to create new documents. While I’m one of those who lives in the command line and does much of their writing in vim, you can get a great velocity and fluidity with VScode or similar I expect. The downside is that you need to commit and push regularly, the upside is that you learn to commit and push regularly. This is especially helpful when you add useful commit messages, giving you almost a free indexing system for your notes.
I’ve been using this system for almost a decade now, using Slack really got me into using markdown syntax as second nature.
I’m surprised you’re running out of space in google drive though, what size and type of files are you storing in there? Just notes and doc type files shouldn’t get anywhere near the limits.
If you’re storing videos and the like, then I can see it being an issue, but just text and some images? I’d have thought any of the standard ones would be fine.