I've been contemplating to post here for a while, so here we go. I'll skip most switches that I haven't used for a lot of time.
Clicky switches: Cherry MX Blue, buckling spring and complicated white ALPS
I'm not a fan of noisy keyboards, but at least it's consistent with clicky mechanical switches (compared to squeaky cheap rubber domes). Typing on buckling springs sounds like a machine gun, maybe a typewriter. Luckily, there's barely any clack from bottoming out. On the other hand, MX Blue and white ALPS have high-pitched click, usually followed by an annoying clack of bottoming out. Therefore, I prefer them with (EK's) soft-landing pads (yes, it's possible to install this sort of dampeners on ALPS). It doesn't even ruin the experience for me by feeling mushy—in fact, it masks the weird bump of blues right after their sharp tactile point, and also eliminates harsh bottoming out in general. Unfortunately, I'm not able to ride the actuation point on any of these switches, they're too stiff (including blues!) for me, hence I have to smash them (thus bottoming out).
In the end, I somehow wish there was a light-touch, quiet buckling spring. I probably wouldn't go with ALPS, because of almost non-existent availability of PBT keycaps, or Cherry MX Blue—there're plenty of other Cherry switches.
Tactile non-clicky switches: Cherry ML, Cherry MX Clear etc.
This is a sort of a grey area for me. I rather briefly used black ALPS and Cherry MX Brown, but didn't like them, because they felt very gritty to me, at least compared to linear Cherry MX and clicky switches mentioned above. Maybe lubing would help. I had used Cherry ML before that, they felt less scratchy and had more pronounced bump (possibly due to shorter key travel). However, I didn't like them either, because of kind of sticky impression when pressed off-centre... again, it could be solved by application of some lube, though. Once I learned to type on them without bottoming out, they were quite similar to Cherry MX Clear switches: hard to bottom out. Clears are probably my favorite tactile switch. They have a very pronounced bump followed by some sort of a barrier that makes it hard to bottom out. I love that. Stock springs are too stiff for me, thus ergo clears. Unfortunately, I haven't formed an opinion on optimal configuration of ergo clears yet.
I feel like I should experiment with clears more. Or try to lube browns and MLs. Or get some Matias ALPS. (Or go the Topre route, but I guess it's not worth it for me, because Topre price/value ratio and layouts don't work for me. I could get sufficient experience from old high-quality rubber domes, e.g. BTC 5169 or KeyTronic.)
Linear switches: Cherry MX Black, Cherry MX Red, Cherry MY
Long story short, I love smoothness of linear Cherry MX switches. There isn't much to add, only a complaints. It's mostly about stiffness. I barely apply enough force to actuate the black switches (which also means I don't bottom out, which is irrelevant if I miss keystrokes), but usuallly bottom out reds. Therefore, typing isn't silent. Actually, it can't be, due to sound produced by upstroke (obviously louder than on tactile switches), but I can live with that. However, I'd at least appreciate dampened bottoming out... which is almost impossible to solve, because soft-landing pads on linear switches feel unpleasantly mushy to me, and stiffer o-rings (50A) make key travel too short when used with thick Cherry/SP-profile keycaps. Surprisingly, this isn't much of an issue on Cherry MY switches—they get very stiff after actuation (which is a bit similar to Cherry MX Clears), so it's almost impossible to bottom out. On the other hand, they're ridiculously mushy. That makes them very annoying for non-industrial use... with one exception: if you remove springs from Cherry MY switches (BTW it doesn't require any soldering), they become extremely light (like 25 cN to actuate), thus suitable for (a) people with some health issues, or (b) learning to touch type (you can't even rest your fingers on keys).
Finally, a keyboard with Cherry MX Red switches is my daily driver. I'd love to try both stiffer and lighter springs inside it, but I guess I'm quite happy even without that.