No right or wrong here. It's really your choice. The question you need to ask yourself is, "how much will it get used? if you get a seasonal site. Of course, if you use it every day, you are truly getting your money's worth. If you use it only one time, you're just wasting your resources.
Personally, I am not a seasonal campsite camper at all. We may return to the same State Park (which we have many times), but find it most satisfying to have a new spot each time. However, I enjoy towing, driving, the set-up, breaking camp, and even clean-up once home. I would find it very boring to just show up and go home at the same place every time (personally).
But for those who do enjoy the seasonal site, they enjoy the ease of no repetitive set-up or breaking camp, towing, driving, and all the logistics of finding new campsites every time you go out.
Maybe another advantage for a season site are better rates over a long term, (when you think of how much one night costs), opposed to someone who is using the same campground for just one night. But, there again, if you don't use it except for 1 night a week, at (say) $10 a night for seasonal, and you're there only 1 night a week, you've paid $70 for that one night. So is the cost for not having to set up and take down, and drive and clean up worth $60? Opposed to someone who shows up for a single night and their rent is $20 for one night and they are gone? There again, the cost is a factor and savings the more you camp there on a seasonal site.
Either way, seasonal or transient, neither one will have to mow grass or tend to the maintenance of the property.
It's really your call. But seriously, only you can make that call, "How much will the seasonal site be used to maximize the cost involved?"