My advice is to seek out some free samples, try what you have around the house, and ask your friends if you can try some of whatever they have. It's not a bad idea to search the Internet to see what other people say, but that wasn't terribly helpful to me since most of the reviews cover just one product: "I use product x on my tush and like it." It wasn't clear whether they tried any alternatives and why the other stuff was not as good. Cycling Coach Levi posted a great introduction to chamois and chamois butter but likewise did not give a detailed comparison of the products he mentioned. So that's what I try to do here. This is my first stab at a multi-product review.
For those of you who just want me to tell you what to buy, I'll go ahead and spill the disappointing beans and say that it seems that different solutions work for different people and everyone has their favorite. You might as well stop reading here and start trying stuff. For you analytical types who are interested in the experience report, read on.
Criteria
I was hoping to find a cheap solution that worked. A real value. But since my comfort on long rides is valuable to me, a product that actually works trumps cheap. My approach was to try the solutions lying around the house and those I was able to easily get free samples for. I didn't try to get samples of all options. I've been told to try Assos and Boudreaux's Butt Paste and Nubütte but I haven't gotten any.
Warning:
Graphic Details. Some of the following may not be suitable for young children or anyone else.

sample at a BRAG Spring Tune-Up ride. Like many of the solutions, it's feels yucky in your shorts. Or, it does for a short time. Once it warms up and soaks in you forget about it. I don't remember its scent, which is a good thing. It's a little thicker than hand lotion, as are all of the products reviewed here.
Back in August I rode with some friends from Smyrna to Anniston, a 96 mile bike ride. My fanny faired none too well. I forgot to apply chamois cream before the ride and had a badly chaffed behind by the 60 mile point. That's about where we stopped for lunch and Bob O'Neal let me use some of his Bag Balm. Didn't seem to help, but perhaps it was too late. It also didn't smell good, but then what should I expect out of a product to rub on your rump?

The Udderly Smooth Udder Cream is cool and very slippery. It feels colder than most when you apply it to your posterior. It smells a little like sun block or cold cream. It's smell is mild, which is a plus for me since I am sensitive to smells. Perfumes and mediciney smells clog my sinuses and make my eyes itch.
In September I tried Balmex Diaper Rash Cream for the MS 150 on the 60 and 100 mile routes. The Balmex worked fairly well, but not perfectly. I still had hot-spots and felt the need to reapply it often. Balmex is thicker, stickier and feels drier than the Udder Cream and all of the other products here. It's very difficult to wash off your hands, something to consider on a long ride where the you may not have good hand washing opportunities. Balmex has a mediciney smell; an unmistakable diaper rash ointment aroma.
I had some Desitin Creamy diaper rash ointment on hand but chose to not try it. It is just about as thick as the Balmex and, after the Udder incident, I wanted something thick. Balmex and Desitin are waterproof, which is great on your bum but that makes it difficult to wash off your hands. Desitin has a more mild smell than Balmex. Perhaps the main reason I chose Balmex that time is that Desitin and Aquaphor and many other products you likely have lying around your house contain petrolatum (petroleum jelly). I've heard a few warnings about this ingredient clogging your pores, not washing out of shorts, and possibly breaking down the petroleum-based fabric in your Lycra/Spandex shorts. I don't know if any of that is true, so I recklessly perpetuate the rumor here.

On the way back we stopped for a break. I was hurting. Mainly my left knee and my buttocks. But the pain was in the gluteus maximus, the muscles in the rear, rather than a rear end rash. Nevertheless, as is the custom when stopping for a bio break, I applied a new layer of the Sportique. I'm not saying it was the Sportique, but that break gave me a second wind and I rode strong to the end. I had no rash that day or the next.
The Sportique is nice and thick. You know that wet feeling of rubbing on some hand lotion but not rubbing it in all the way? I got that feeling with the other products, but not as much with this one. Not sure if it's because it's thicker or because it has some kind of warming agent in it or something else. It doesn't feel as wet or yucky in my pants.
A Bicycling Magazine review says it smells like cinnamon. I wish! It smells like a medicine cabinet. It has two of my least favorite scents, eucalyptus and wintergreen. It smells like some kind of combination of those and the other 40 ingredients. That wouldn't be so bad if it was just on my derrière, but it's impossible to wash the smell off your fingers.
Sportique claims antifungal and antimicrobial ingredients. Assos claims to prevent bacterial and fungal infections. I saw no such claims for the other products.
So there you have it. I've come to think the chamois specific products have the edge, but I'd like to give Udderly Smooth another shot. If smell is not an issue for you, I'd recommend the Sportique. If it is, give Paceline a try.
Question for you:
If you have tried more than one chamois cream, what have you tried and why is one better than the other?