In a nutshell, mahogany tops have a very warm mellow "blended" sound, without as strong a treble or for that matter, as honkin' a bass as a softwood top provides. Makes a nice-sounding strumming guitar. For more intricate playing, I'd say they don't have the punch. (They're typically small-bodied guitars too.)

W-O