OK. I use filtered water to water my indoor plants. But not all the time, and you also have to remember that I use my own compost based
potting mix (except orchids, though I'm starting to experiment).
Mostly, I'm looking for de-chlorination. Upstairs, I use Copper-Zinc de-chlorinator on my shower and use the water collected while the shower warms up, etc.
In the kitchen, I use filtered water for immediate use (as in "OMG I didn't realize you were so dry!"
), but I also usually use it to rinse out my French press coffee carafe with it and water, so the plants are getting weak used coffee ground water. I also usually boil without adding salt and use the water from boiling pasta, eggs, edamame and a few other vegs. I use filtered water for 2nd and 3rd rinsing of rice or beans prior to cooking, and salad greens, and the used water goes in the watering can.
For misting, I use filtered tap water.
I do think rain water is the best. Next best, I understand, is boiled and cooled tap water. I did collect snow in buckets and have been using melted snow water for my seedlings. I guess I might continue and fetch some water from my rainbarrels, but the sooner the indoor plants can go out the better.
My 3 rosemary, lemon thyme/scented geranium, and stevia went out yesterday, and I did put one citrus out already.
Getting back your list of plants, my orchids are upstairs so I generally use the de-chlorinated tap water. Sometimes, I'll be generous and bring up the "fortified" water from the kitchen, particularly the used coffee ground water which I think suits orchid needs. I don't have cacti but most of my succulents are upstairs. Night-blooming Cereus is downstairs and gets the water from the kitchen. Don't have a terrarium at the moment, but the biggest issue, I think, is mineral build-up.