If in an aquarium they need room to spin around, they aren't the best drivers depending on species lol. Live plants as always are best but they don't need so many that they can't swim. Goldfish and their relatives poop A LOT, so bare bottom is the easiest to clean, sand is a nightmare. So if you use substrate I would say gravel is better as long as you have a gravel vac. I have a koi-shubunkin hybrid in my bedroom tank. Him and a high fin pleco share a 75gallon until the hybrid gets older and he goes to a pond. There are hides for the pleco, a few tall plants and a couple pieces of driftwood and some larger stones so my pleco has something to hide in and hangout on. The koi-goldfish doesnt do much but swim around the top and middle of the tank