Will the categories actually help? I mostly find that I search for the username or site name, and then it doesn't really matter if they're in a folder.

Also this is a rrrrreal nitpick but if you're keeping them in the database, are they really throwaway?

When you separate them into different databases you add the unnecessary steps of having to remember where you put it. And when you create the password you have to decide how to sort it in. And what happens when a less important thing turns out to be quite fun and you'd promote it from less important to hobby?

Just save the passwords with the URL, name and maybe a descriptive tag or two. Let the password manager deal with bringing up the correct password.

I don't really see the need to organize passwords in a password manager. It's sufficient to be able to search, along with the right credentials being suggested to the right website/app

Decoy passwords on post-it notes.

I don't bother categorizing them, as someone else said it's just extra steps, for what? When I need a password it either autofills or I search for it by name.

I use keepassXC for passwords. One database. I organize by category. Shopping. Finance. Email. etc...
Then I sync that to my phone using syncthing. I have hundreds of entries and the database is still less than 1mb.

Keepass has a folder structure so you can organize the passwords by type. I used to do that with my stuff, but as others have said, I gave up and just search for them now

The password manager I use lets me create a hierarchy so I can subcategorise. Reading the other comments here suggests that it's not a unique feature and so I'll hazard a guess that most of them can do the same thing.

It also supports different databases if you really want to go that route, but since that means you'll need a different password for each one, you're undoing some of the work of having a password database in the first place... unless you intend to have a master password database with a master master password. That just hurts my head to think about.

Just give them sensibly labels and tags when making them so they are findable and usable. Don't fret over organization beyond that, it won't improve your quality of life, go for a walk or something instead.

A bunch of cryptic notes in Notepad.

Why separate them? You will need to keep the most secure one anyways, might as well store everything there.

I sort mine by taste

Use tags if available, and I keep my frequently used / primary ones in a different directory.

That way you can still display account per categories if needed.

I just use Password1? for everything. No need to organize.

Make sure the password to that master database is written down someplace safe. Make sure your will specifies where to find it. This means the witnesses to your will and your lawyer know where to find it, so make sure you can trust them. (A lawyer might even know of a good safe place to put it). If you don't have a will and won't get one, find an alternative for at least these.

When you die your estate needs to get into your account and pay your bills. A few online forums are personal enough that you should have them post your obituary (most are too anonymous - but some you get to know the other members). Hopefully your death is a long ways away, but it will come.