If silicone lubricant were compatible with all silicone toys, it would be the clear choice for me, as I've never had any issues with irritation, and while it feels a little oily, it lasts a long time. For any metal or glass toys, as well as sex, I would choose it, easily, since my butt is so picky about water-based lubes.
Water-based lubes vary widely for me based on their ingredients. It would seem I'm a bit sensitive to certain ingredients, and some of the most natural lubricants still manage to sting sometimes. Luckily, I've found a few from Sliquid that agree with me.