When we talk about Silicone or water based lubes, we are talking about the main ingredient. You can't decide if is good or bad just with that.
It is not the same a silicone lube with Dimethicone and Dimethiconol, that a silicone lube with Polydimethylsiloxane, Decamethylsyclopentasi loxane, Octamethylcyclotetrasi loxane, Dimethylsiloxane, Hydroxy-terminated Capsium, Peppermint.
So in the first one, you need to check how safe are those 2 ingredients. In the second, you need to check a lot more.
Now you can see you can't just say is safe or it is not safe just because the main ingredient or the lube type.
To the use you want to give, I will try to get a simple formula. DL lubes (Dr love or Getmaxxx) are the safer one talking about silicone based.
Here you have 2 links to check ingredients safety: