We started with water based, moved to anal lubes and then on to baby oil some years ago.
That said I generally use water based when I am using a prostate massager on my own because it doesn't go everywhere - easy to clean up afterwards.
Never had any problem with baby oil and a variety of silicon based toys.