I've generally found that the order of the names on the doorbell list roughly matches your floor. So if you're on the 2nd floor, right side from the stairs, your doorbell is second from the bottom, on the right side.
Obviously, there's no standard nor convention, but Hausmeisters seem to find it convenient, and I like it when I can do that when visiting a friend for the first time.
Of course there are, however, apartments whose Haustür (the door to the apartment building) leads to several different buildings or staircases. In that case, good luck ever finding that person even if they want you to come visit.
In my city (Leipzig), all apartments have these. All the last names are listed on doorbells, and you have a phone in your flat, from which you can unlock the apartment building's front door without coming down.
So, in total, your name is three places in the apartment: at the entrance next to a doorbell (which effectively "calls" your flat), on your mailbox, and above the actual doorbell near your flat's front door.
I live in Leipzig and I have no name on the doorbell near my flat door. If they deliver a packet to a neihgbor I have to go out and ring the doorbell at the entrance, or guess which apartment it is :)
Never seen this in Germany. Not that I remember, but most places, no, this doesn't happen.
"downstairs/apartment building's set of doorbells also proclaims last names, and are often ordered by floor"
They thought of that. So they mix it up, or just list, it has nothing to do with floors
"In fact, it's advised that you don't put any first initials/first names on your doorbell"
Correct, they usually put last names only.