When I was researching different brands of trailers I went to forums for those brands. Last year I rented a Jayco motorhome for a month and at their forum lots of people just used the house brand from Costco and didn't have any problems. I used that during the rental and everything was fine. I plan to do the same in the trailer.
Soft and cushy enough for the tushy is my criteria!
And using enough water so you don't get that dreaded tower of TP in your unit. Um, yeah. Don't want that.
There are a bunch of videos of people putting TP into canisters of water, letting them sit and shaking them up. Stuff like that. They will test different brands, some of which was the Costco brand. It passed their tests, as did some others that are softer (and cheaper) than the labeled RV TP paper.
Nice to know that you don't have to spend your @$$ off for TP.
On our sailboat, NO TP went into the head. A sealed plastic bag was the receptacle for TP, thrown out with the trash at the next port. Much easier on the plumbing, and you can use the brand of TP that's right for your tushy!