I had a rock tumbler as a young kid. It worked just like it was supposed to and did a great job, but was loud.
When you opened it after a week of tumbling, it just looked like grey gritty mud. Cleaning it for the next batch was not a lot of fun for a kid, and waiting for over a month for the results was also not great. But the results where excellent.
You can try polishing your own local rocks you find, but you will have varying success. The rocks that usually come with the kit can be bought, and are the 8 or so types that generally give the best results.
I think they can be useful as decorations when the stones are polished. Maybe at the bottom of a glass vase or something like that. When I was at Canadian Tire today they were selling boxes of river stones for decoration. Another good place is in and around a fountain driven by a pump.