What kind of finish you can get depends on the coarseness of the stones you use. To get a mirror finish you have to finish with cork and compound. Most stones are coarse enough to clean up the bore, but too coarse to polish.
For engine cylinders, you want some roughness to break in the rings. On bores that take rubber seals, like all the brake components, you want them as smooth as you can get them.
Also, the cylinders are not expensive, so don't spend too much time on them.