I will say with the Mario Pipes I wish there was a way to change the color of the pipe. I mean come on if you played any Mario game you would remember that the pipes are in different colors like Yellow, Red, and Blue for example.
I have two pipes, but I don't keep them on my island permanently. I usually only use them whenever I'm digging up overgrown flowers or picking up weeds so I can get to Nook's Cranny quicker instead of running back and forth.
I used to have one in my house to the airport because I didn't have bridges. How I just bring a storage shed and trashcan to the area I'm decorating and don't have to run back and forth anymore.
The pipes are useful when you have your home so far away from the Plaza and if you want to get their faster just have a pipe by your home and then one at the Plaza and then thats it, you'll be able to get there in seconds.
When they were first introduced, I was excited about the possibilities, but never really got into using them extensively. The randomization when you have more than two pipes does make it less convenient and does seem to counter the idea of quick transportation, so I've stuck with just one back-and-forth set of pipes.
I do, they are quite useful but sadly pretty ugly at the same time. I have one placed inside of my house and one next to the shop area, hidden behind a tree so it wouldn't ruin this part of the island.