Lake Berryessa is huge, with a ton of trails and smaller rivers that are safer to swim in. My ex and I used to take mushrooms and go hiking there on weekends. The glory hole is magnificent to view from a safe spot. Sadly, California has not gotten a lot of rain in the last few years, so I doubt the water level is above the hole right now.