Well, for a finger player, I would not hesitate in recomending a cedar top.
I can't remember when exactly I got my acoustic.... has to be more than 12 years ago now,
and it's the only one I've ever had.
A cedar top. (Ovation Custom Balladeer - I wouldn't recomend getting an Ovation though
It's served my style well (The cedar top that is).
I alternate between using my fingers/thumb to pick and sometimes pluck the strings, to
strumming with either the side (tip) of my index finger, or pinching my index/thumb together
(As if holding an imaginary pick)
I would imagine that a light gauge pick might be able to be used... Though I prefer to use HEAVY picks when
I actually do use them (on my electric).
I have a very light touch, and dislike the 'sound' of floppy picks LOL.
I know several people with spruce top/ mahogany side/back acoustics (and I've played many others at GC),
and playing with my fingers.... can't get any volume out of 'em.
Even when I finally break down and grab a pick; since I play so softly with them as well, I have a hard time
getting a decent volume out of them.
And as far as tone goes - Mahogany is suppose to produce 'bright airy trebles' (according to Martin)....
To my ear mahogany saps treble.
It's a very low end sound to me.
(as was my old 60's Gibbo SG - all mahogany.... Very much lacking in high end)
(as opposed to George Harrison's all rosewood Tele - beautiful high end sparkle, and wonderful even overall sound)
The Takamine Tan16C that I played had that quality - A nice EVEN sound across the frequencies.
Well balanced soundwise.
It was the only spruce top guitar I've played that I actually liked.
It would be hard for me to recomend a cedar top over that Takamine.
As I said - it had the most brilliant multi-dimensional sound to it....
Having the lower (regular acoustic) sound, with a real.... ummmm, almost like a muted string strum on top of that.
Just beautiful for strumming.
So full of character.
That guitar aside - cedar over spruce for finger style.
And Rosewood over mahogany for the sides and back.
The Tan16C has a solid spruce top, and a solid rosewood back....
The sides are actually rosewood laminate.
I'm sure solid rosewood sides would cost a bit more.
Alot of the sound in an acoustic actually comes from the inside bracing as well.
I don't know what kind was on that Takamine - though I remember being able to clearly see it while I was playing.
(Unlike my Ovation, haha)
It also has a rosewood fretboard - which has a nice warm sound and the slowest note decay.
(as opposed to my Ovation, which has an ebony fretboard. They have the coldest sound and fastest note decay)
So there are a few factors for you to consider.
And regardless of how I like my acoustics.... You have to find a sound that You like.
So - go ahead and use this info as a guide, and go try as many acoustics as you can.
Having this info on hand will make it easier for you to identify the qualities that you find pleasing.
Again - Good Luck,
and keep us posted!