EOS good choice for product shooting?

I need to equip and setup a studio for shooting products for web sales. Everything from small items like pens to clothing on mannequins. The question is would the EOS series be a good choice. I would like to connect to a PC using photoshop to preview. Is this possible? Can anyone suggest a lighting package that would fill the bill? Sorry about the multiude of questions, but I'm desperate and don't know where to turn. One last question, any good instructional video sets on studio shooting available?
Thanks
Chris

What's your background? Any experience with this? There's a bit more to shooting stuff then just buying a camera....
To your questions:
It's not possible to get a 'preview' on PC with any DSLR; the mirror is in the way. You can shoot thethered with the Canons (at least with the 1D series, but I think with all)
Lighting: It's not what you've got, It's what you do with it... You'll ligt a pen different then a mannequin...
Instructions: some (obviously biased) here

I'm a graphic designer (CD Web Print etc.) I have been trying to do this with a Nikon Coolpix 4300 (POS!) Have tried all setting manual and auto. Just looks bad. Lighting is some stands w/tungsten continuous 250/500w lamps from B&H. I want to go to the next level and hopefully avoid so much Photoshop post work. Final output is a 70 pixel wide thumbnail, a 150 pixel large thumbnail, a 550 pixel detail and a 1200 pixel for zoom feature. All are 72 dpi.

Well, frankly, for that kind of output, a Coolpix should be quite enough (at least for the tabletop work). Lighting is most important here.

Most in your situation select a small digital camera on a small tripod with the small product in a softbox. I think a dSLR will do an excellent job, but I think for your needs a nice digicam will do the same job for a lot less.

The Coolpix 4300 should be more than what you need for what you are doing. Maybe post a pic on here with the exif info and someone can give you some pointers on what you are doing wrong and ways you can fix the problem.

Any reason why you can't hire a pro?