PS/Illustrator are all CPU/RAM (mostly RAM, especially if you work on very large images and/or keep many files open at once.)
Maya/Rhino/3DSMAX rely on the video card for doing realtime previews, but if you are doing 'real' rendering/raytracing, that's all CPU. These programs may run significantly better on a 'professional' video card (Wildcat/Quadro/FireGL) which has optimized drivers and firmware for 3D modeling applications. However, such cards are considerably more expensive than their 'gaming' brethren (although sometimes you can change the BIOS on a 'gaming' card to turn it into a 'professional' model).
For specialized applications, it's best to consult with people who have used them and have experience with what kind of hardware is actually required for different workloads. If your friend is doing smaller/less complex models, you may not need much of a video card. If he wants to work on things with hundreds of millions of polys, you'll need something quite powerful or it will run very slowly.