We all see things differently so here is how I see things.
If you take desireable woods like cherry or mahogany they will look good whether stained ot not. All the stain usually does it darken it somewhat.
If you take some of the less desirable woods like birch or poplar you are still just darkening it to make it look better, but they still lack the 'character' of the more expensive woods.
You can never give pine the same appeal as walnut no matter what you do to it. Walnut also speaks fopr itself whether stained or not.
Retired, living and cruising full-time on my boat.
Currently on the Little Tennessee River near Knoxville