During my recent month long motor home rental I used the two ply from Costco (their brand). I was part of another forum at the time and lots of folks said it worked just fine. It's what we use at home and it's fairly cushy to the tushy. As long as I used plenty of water when flushing the tank, it was fine. I found out the hard way I wasn't using enough water when flushing. Used more water and things were fine.
Having a compactable and flexible sewer hose made a big difference. Sometimes I was parked close to the sewer hookup and other times I wasn't. Some of the campsites required you to have the attachment that screws in to the hookup, while others didn't have a screw-in and you just plunked the hose (with the attachment) in there. (Don't worry, the hose doesn't fall through.)
I learned a lot during the trip just by asking others parked next to me. They were all willing to come over to help when I asked for it. I just told them I was new to this and would appreciate some help. (And I lost count of how many women told me they didn't know how to do all that and left it all to their husbands, including the driving, when they discovered I was doing this on my own. Jeez.)
A fair amount of folks used this slinky type set up to put under their sewer hose. Don't know what they're called, but I could see the advantage of it, especially if you're parked somewhere for a while. It's supposed to make the water and stuff flow better into the septic tanks. It raises up the hose so it's not sitting flat on the ground. I did get kind of tired of lifting the hose up and down to make sure everything was out of there. Hopefully the slinky thingies would help with that.