It's different for everyone.
First of all, if you're still using Surgilube, stop right now. That requires douching after, and that complicates everything and can lead to yeast infections. And THAT is not a subject you want to be researching. (I got some bad ones. Spending $40 for a single capsule to poke up your snooch, and then hoping for the best, is not any way to spend a week.)
I tried AstroGlide, but it made me itch. Something in it I'm allergic to, I believe. With a friend's guidance, I ended up with a water-based lube that worked better, but it didn't last long enough and I ended up having to reapply a lot. Nothing like repeatedly reaching for a plastic bottle to break the mood!
Ultimately for me, nothing has come close to Replens. It's expensive, but it has some nice advantages (in my mind, at least). It has the appearance and consistency of cum. It smells not unpleasant. It even has a slight taste of cum (a bit salty). You can use it on your stent or vibrator and it won't dissolve away right away. AND if you're the dry type and want to have sex with your guy, it's not going to get in the way with any weird taste or smell. You can pre-lube and have your evening of fun. It's marketed to cis women. Maybe there are generic alternatives now.