Check out The real culprits article by S Rajesh. His analysis of Indian batsman clearly shows where we have been failing.
He compares batsman scorecard in good and bad conditions. Good conditions consist of favorable tracks and mediocore bowling attack. Note how Dhoni's performance drops.
Author makes a note of how Kaif actually performed consistent in either of conditions and yet failed to make into World Cup squad.
Article concludes with the note that its bowling which have performed better than our batting in past 2 years while we still call us as a strong batting lineup.
Also checkout Manjrekar's thoughts on Chappell contribution to Indian cricket.