I think there are a decent number of colorful and bright freshwater options but you won't find much in terms of eye-catching colors and patterns, not unless you invest in a salt water tank.
I absolutely love tropical fish. I often find myself going into the pet shop near where I live and just browsing the fish and I am always amazed at how many different ones there are and how good the colors look on some of them. I don't own any tropical fish myself, but I feel that if I was to really look into taking care of tropical fish, it would be something I would look into getting down the road.