When we are working with new designers here at Angled we are constantly asked about surface finish and overall appearance. There are also the questions about material and function.
The short answer is that 3D Printed product can function as well if not better than any other process. As long as the design designs with 3D Printing in mind.
As far as appearance. 3D Printing will generally have a texture. But you can lean into that. You can use the 3D Printing layer lines like the grain in wood. Or you can apply textures to you part that cannot be created without normally have to paint of post process the piece.
But if you are just looking to know what comes off a 3D Printer without all the special design. We highly recommend you check out WildRoseBuilds. This great youtube channel prints all kinds of objects and gives you a good way to see what can come off a printer.