I stopped my membership after years because of Covid and lockdown and haven't felt like renewing. I live about 20 minutes from the ground (walking) and would recommend the full membership if you're retired but you do have to get used to watching County Cricket in a large ground with just a handful of enthusiasts and an echo (not the paper) for company.
The Superblast or whatever they call it now is more of an occasion but only if we're any good. Again, it's a bit miserable when we're crap (which we were a few seasons ago). Better to go to one of those (or get the very good value ST for those games).
I'd renew it just because it's a nice place to soak up the rays and there's free coffee in the members lounge!
I did go to Newport to watch them a few years ago and preferred that. Small, village cricket feel to it against Gloucester and more intimate. I used to like it when we moved around and played at places like Abergavenny, Pontypridd, Ebbw Vale, too.
Of course, if you do get a membership, you get the early bird offer to buy ODI tickets for an England game which I'd say was the best experience each season unless we were doing well.
Sorry, mate, I can be a miserable bugger until at least three coffees and I'm on my first! I'd say, pick one YOU fancy and go for it. It'll probably rain anyway
Edit: and we'll lose!