Covid blew up the RV market. You could go camping but not much else. The lots were empty and prices were high. Now, its just the opposite. Camping wasn't what people really wanted. 2-3 year old units are abundant and prices have come down.
RVs are built cheap - that's true. But they only suffer if driven around a lot. Situated on a permanent site and they will last a long time with regular maintenance (keep the roof sealed up)
We decided to own camping property 33 years ago. Didn't have a lot of money so be bought an oldie. Our son bought another one a few years later. Our 2 campers are 1961 and 1964 models. Both haven't moved in 33 years. Of course they built everything better back then)
Our initial $3000 land investment is now worth $150,000. We upgraded one trailer in 2015, and just a month ago our son bought a new 2023 model, and got a smoking deal.
Our acreage started out with $100/year taxes. Now they are about $500. The trailers are not taxed because they are motor vehicles. Building a cabin would not be cost effective for us. If we build a year round house it would be different.
IMHO, leased land in a campground is foolish. There is no better investment than land.