After reading all of our responses, I realized we haven’t really given any advice or opinions on the specific question of, “assuming I buy a cassette or portable toilet, what size should I buy?”
Making sure you stay within any exterior dimension limitations you have (like storage cabinet size), or seat height requirements due to knees or other issues, is pretty straightforward for the OP to assess. However, he might want opinions on fresh and waste tank capacities.
My Thetford 345 has a 4 gallon fresh water tank and a 3.2 gallon waste tank. (Note that the bigger 365 has the same top section and 4 gallon fresh tank, but has a bigger waste tank).
If we are staying in campgrounds, we use the campground facilities as much as possible, so I won’t muddy the estimates by bringing in campground camping. If it’s just me on a remote trip, I could easily use it for a week or 10 days before needing to empty it because almost all peeing is done elsewhere or using a bottle emptied elsewhere. In that scenario I typically empty it well before it’s full if I have the opportunity just so it’s not smelly when you flush.
However, if my wife is with me, the waste tank fills up much faster because she’s using it pretty much every time for everything, and we can go about 3 -4 nights before it is getting near full. She drinks a lot of water. If my wife and school-age granddaughter are with me, it must be emptied every other day.
The fresh water tank, if it starts completely full, lasts for about two waste tanks. The toilet is pretty heavy and top heavy when the waste tank is empty and the fresh tank is full, so I only fill it halfway on weekend trips. For long trips I fill it completely because it adds to the total water capacity in the camper.