Definitely not a professional but I think I've got and tried every type of brass cleaning gear. I decap all my brass first whatever the case. The SS pin tumbler is the best clean, particularly for really dirty brass. They come out shiny and squeaky clean inside and out but with slightly dinged up case mouths, it doesn't really matter as I chamfer them but I mandrel size the necks with dry lube after cleaning the lube off and prior to seating the bullets so they're lubed a little.
The dry tumbler with walnut media leaves a nice finish but doesn't clean the primer pockets or inside the case as well and bits get stuck in the flash holes. It's completely harmless to the brass though, no damage to the case mouths and the necks aren't squeaky clean so the bullets seat easier. It's annoying blowing the flash holes out though. I mandrel size the cases before the final clean with the dry tumbler.
The ultrasonic is quick and leaves the cases really clean, I bought a big one recently and it's my go-to cleaner now. Heated to 50 degrees C it takes 30 minutes for a couple of hundred cases and they're as clean as they're going to get, it just doesn't polish them. I give them a quick rinse and blow the majority of the water off with an air blower, they dry really well in the annealer!
I reuse the fluid until it doesn't clean as well, probably around 1000 cases. It works well to clean the lube off after sizing as well, I've got a food dehydrator I put them in to dry after that. The ultrasonic doesn't seem to clean the inside of the necks as squeaky clean as the wet tumbler so feels better seating the bullets.
To be honest, I don't think it makes any difference to the way the loaded ammo shoots whichever one you do. All 3 end up with single digit SD's and dirty cases with a brush through the neck do the same. Clean cases don't dirty up the dies though and are much nicer to work with, it's also a good way to notice issues with the brass which you might not see if they weren't clean.