I have a Canon 20D and love it but you still need good light for indoor shooting. If your not interested in an interchangable lens camera try a point and shoot with a flash shoe. My last camera was a Canon G2, I added a Canon 420ex flash for indoor shooting. The Canon G6 or Pro1 will accept an outboard flash. Check out the photo forums for more ideas. Good luck on opening this new money hole! Mike
I'd say again, that you'll need a tripod instead. Even in low light you can take relatively good pictures, since the tripod allows you to shoot with longer shutter times w./out handshake.
And yes, for _good_ pictures good lighting is needed, and setting of lights (planning the image before picture taking) is crucial. Unfortunately hot shoe flashes like Canons EX420/430 are not very good, even if pointed upwards (flashlight bounced via roof) or flash diffusers (like STO-FEN Omni-Bounce and similar) are used. They are not good (or perfect) because:
a) The light source is too small and uneven
b) The light source is too close of the camera.
The hot shoe flashes are good for documenting the happening, or rapid/instant shooting of objects/people. They are not ment for product shooting/non-moving objects in general.
As this slightly off-topic might interest many members, here's an ABC for good product shooting (and lighting).
1) Always shoot from a tripod. Use the self timer mode. Don't have tripod and don't want to spend the dough? Bring a chair/table and put the camera on it, and use the self timer (remote release, if you have one). Use whatever, cardboard pieces underneath the camera or a bean bag or similar to angle the camera to the object.
2) Fiat lux. Bring on the additive lighting. Digital cameras are cool, because on most of them, the cameras let you set the white balance. Different lightsources have different colours (colour temperature), even if in real life you don't see it, since human eyes are more adabtable to the lighting, than the unintelligent machine (camera). You'll notice different light colours, when the image is taken, and the picture is reddish/bluish/yellowish, etc.
Setting/adjusting the white balance gives the opportunity to use nearly all kinds of lights and have white as white, not bluish, slightly rose, etc. Floorlamps are okay, table and roof lamps too.
3) Avoid over shine/washed out images. If possible, try to avoid direct lighting of the object, when possible, when shooting bright objects, like lacquered frames, polished objects, etc. One can bounce the light using styrofoam boards, white thick sheets, white carboard and so on. This gives a softer light, without harsh shadows on the object. If you use primary light say from your right side from 45 degrees angle of the object, use another (slighlty less powerful) light from your left side, again 45 degrees from the object to counter effect the shadow from the primary light. If your room is big enough, the distance from the light to the object can be used to lessen/enhance the intensity of lighting.
4) Choose the backround. The ubiquitious garage door shouldn't be the only option. Nor should be the white canvas/sheet taped on the wall and partially over the floor. Use your imagination.
5) Perspective. The cameras/lenses can distort images badly. Try to shoot atleast one general photo of a bike from waist level, or slightly lover - from the centre of the bike frame. Take photos from other angles too.
Most cameras have zoom lenses, but don't forget that you have legs. Use your leg-zoom to make the desired crop.
6) Aperture/DOF. Want an artsy photo with the backround nicely blurred, and the object steps up nicely from the photo? You need shallow depth of field then. Learn what is depth of field (DOF) and what has aperture got to do with it. Compact cameras have deep DOF, since their image sensors are small. SLR-cameras sensors are bigger, and have the possibility to have shallower DOFs.
Edit: Some typos fixed