To this day, I still don't understand what chamois butter is used for...

To prevent chafing?

I can imagine it being a greasy mess, like riding around with a wet diaper or something.

And um...i'm picturing a big goopy mess after a long ride. Or does it somehow get absorbed into your skin or shorts?