I've use both, but will never use the clear vinyl as it's very hard to get positioned where you need it and, you'll see the gross algae and crap inside.
I do use silicone tubing coming out of every pump and out of the sump, so there's no noise & vibration's. It's expensive, but I only use around 6" or so.
The hot tub white soft tubing is great and it looks real nice, but not very flexible. So, most of mine is hard, but I sand the ugly white and remove the printing. For my latest build I will fork over the money for colored hard pvc or paint it myself. It's just for myself as it's a in-wall, so everything is in the fish room where you can't see anything. I like anything & everything...nice looking. (That's why I married my blonde.... wife) ;)