I have tried to love silicone based lubes, but they just don't cut it for me. I've actually found that they tend to be incredibly watery and difficult to control because of it. They seem to spread really fast and don't stay where I need it, thus forcing me to apply more. The greasy feeling also bugs me. I prefer the thicker lubes like Maximus for toy play and anal. I am currently in love with Sliquid Silk and Liquid Silk (same company that makes Maximus) which are both hybrids and creamy which is much more natural feeling to me. They are my first choice for penis to vaginal sex, but aren't safe with silicone toys because of the silicone in them. I've found that silicone lube doesn't last as long as Maximus does for me, because the Maximus stays where I put it and doesn't end up feeling like somebody prayed me down with Pam. Silicone also leaves more friction than a good water based lube does, which I don't like. The Hybrid water based lubes with silicone in them seem to be my favorites, though they won't knock Maximus off the pedestal for me.
I used a sample of Bodyfluid (silicone lube by fun factory) last night, and we fell asleep right after sex, without bothering to clean up first, gross I know. Anyways I was still greasy for our "good morning" sex, and while it was nice to not have to put on more lube, I didn't feel sexy at all. I purposefully avoided looking at the sheets, because I am sure they are a mess. Water based lubes don't stain either as a general rule, which is nice for messy people like my husband and I. I want to try the O'My flavored and natural lubes too, as they sound fantastic.
I think the whole debate over which is better, silicone or water based, is such a personal choice. For me the cons outweigh the pros for silicone lube, but for others the pros outweigh the cons. I would suggest anyone who uses lube for vaginal uses (I haven't tried either for anal play yet) at least try one of the Liquid Silk or Sliquid Silk lubes, as they feel amazing and are long lasting but easy to clean off. They really are awesome