Sobering up before trying to find ways of organising songs would be my first tip.

You mentioned art block which makes me think you are talking about your own music you made, not published music that can be tagged and organized by artist and album. If that is the case, I suggest a serialized naming convention. It can be as simple as untitled100, untitled101, etc. For me it’s easier to remember the number than it is to remember what “dhfhsijfjga” sounds like.

Lidarr will probably be your friend.
Utilizes Musicbrainz.
If it ain’t in their database, you can add it yourself and just need to wait 7 days ubtil it’s published.

Edit: I noticed it’s about personal recordings? In that case I am not really sure.
Still musicbrainz + Lidarr?

Not sure if this is what you mean but try using the software Easytag to change each of the files music tags in bulk. Not sure if it supports .wav files though

If it’s other people’s albums: beets is pretty good.

If it’s your own stuff you’re working on: oh no I have no idea I end up naming things like CoolSong20230914-version19final3good.wav

MusicBee can help you organize your songs. Import the files to your library, make sure the tags are correct, and then Tools -> Organize Files