We use Pjur silicone lubes a lot (as well as Liquid Silk which is water based with 2% silicone). The Pjur original is actually quite thick - thicker than the Liquid Silk I would say. Pjur "Woman" is thinner but not exactly runny.
One thing you need to remember is that compared to water-based lubes you need a very small amount of silicone - my guess is that we use about 1/5th as much silicone as we do if using a water-based lube. If you remember this you won't get issues with staining things. The Pjur lubes come in bottles with small holes that mean you won't get gallons of it rushing out unexpectedly.
Silicones are fine on condoms which are latex - rubberists use silicones by the bucket to shine their very expensive latex garments and they wouldn't do that if it harmed them.
The lubrication properties of silicone and water based lubes are different. Water based lubes are usually non-Newtonian and become thinner the more they are sheared. This does make them good at making things very slick but unfortunately they dry out and loose their slick quite quickly. Silicones are not quite so good at making toys very slick but they continue to work almost unchanged for hours. We use a combination - silicone on its own for PIV sex but silicone and Liquid Silk with toys.
Now there are lots of people who say silicone oil 'goes' for silicone toys but this is not our experience with Pjur Original and Tantus, Fun Factory, and Vixen toys (plus some others). We actually only use silicone toys
We find that Pjur lubes wash off easily with a liquid hand-wash detergent.
One other difference you will notice - silicone lubes are warm to apply. You don't get that cooling that you get with water based lubes. (My guess is that the cooling is due to the water-based lubes evaporating - latent heat and all that jazz)