There was an sram red thread recently where a lot of people talked about whether or not they liked it and whether it was good for small hands.

You don't necessarily have to go all carbon to get rid of all the vibrations... a set of carbon wheels helps a lot with that. carbon fiber seat stays, seat posts, and forks also help a lot. same with carbon handlebars.

I have one all carbon bike & one titanium bike... both of them are a lot nicer with vibrations than my previous aluminum bike... the titanium vibration/bumps are just more... pleasant and not jarring, I'd say.