If the length “limit” you’re targeting is due to actual physical access limitations rather than mainstream public campground “rules” then I would think a Class C would be VERY limiting due to the long rear overhang poor departure angle and lowish ground clearance.
In other words I could hypothetically take your Corolla more places than a 25’ long Moho. Realistically as well.
Everything RV related is a compromise.
If you don’t like the lack of space in a 24’ then you may not like a TC but I don’t see either being limiting for one person to full time and explore in.
However if exploring is the priority like it appears, then a dually pickup with a 10’ ish single or double slide out camper on it will check the “exploring” box much better. Greater ground clearance, much better departure angle if you get the right camper, lots of extra storage if you get a crew cab and the ability to live in the camper for an extended period off the truck and have a passenger vehicle for getting out without folding up camp anytime you want or need to go somewhere.
