Grant writing is a very painful form of writing and I have relatives that have made good money by being good at it[1]. I do believe it would be tough to do research and put the time in to be an acceptable grant writer. Something has got to give.
1) for those writing grant to certain government agencies, yeah, there is an old-boys/girls-club and using an "out" word in your grant is a killer (I've drank a lot of beer over the evolution of the word 'empowerment'). One tip my aunt told me is to volunteer to be a grant reader in DC. You see what everyone else is writing, know why things got accepted, and meet the people in charge.
I have tenured professor relatives and the thing that usually "gives" is the time spent on the actual research. From what I can see they spend a little time teaching, a little time managing grad students, and a lot of time grubbing for grants. I don't consider them scientists at all - they're middle managers.
It's an enormous waste of talent.