We do road riding only.
Have run all sorts of tires/brands in our 35 years of tandeming.
Our current favorites for the last 5 years-or-so are the Maxxis Refuse 700 x 25. They have an Aramid (Kevlar) layer to protect against debris/thorns, 120 psi, are foldable and get good mileage. The best mileage we've gotten on our tandem's Refuse rear tire was an exceptional 2,955 miles.
We are a rather light duo: pilot 135, stoker 112.
Tire selections are great and eventually you'll find some that suit your purpose.
This one works just great for us.
Pedal on TWOgether!
Rudy and Kay/zonatandem.