I think the 420EX suggestion is quite acceptable because it is a good accessory to have. I have one (2 in fact) but to tell you the truth I rarely use it except in events (parties, get togethers) when I don't have much time to stabilize my camera for long exposures. I hate frontal flash and the flat, deer in the headlights effect it does so I bounce the light or diffuse it somehow with tissues ( I've lost 2 Stofen diffusers already).
That said, I am amused by dSLR users that offer the advice "upgrade to a dSLR your G camera is a toy". Particularly those who have not owned a G-series camera themselves, and base their opinion on having a lesser but still capable Canon P and S camera. I think it is just silly to make comments about a camera that they probably haven't even touched, much less learned. For the record, and I have mentioned this before, I do own own a dSLR and a quiver of lenses for it, but I still find that I prefer my G6 for certain situations, such as when I need a compact camera, I need stealth (it's great for street photography), and I need to hoist it up for unusual angles (pole photography). I can strap it onto my bike's handlebar, turn the intervalometer on and take interesting pictures, the list goes on.
Unfortunately the G6 is not too good in low light. Let me rephrase that - it is not too good when pushed to ISO 400, as it develops the aforementioned noise. What I can recommend is, to use a lower ISO (100 if you can, 200 in a pinch) and stabilize your camera by using a tripod or bracing it against something. Use the wider range to maximize handholdability. Switch to Manual or use Exposure Compensation to deliberately underexpose your pictures around 1 stop (up to 2 in a pinch) and shoot in RAW. The reason is that digital is forgiving up to +/- 2 EV and you cen use post processing to extract a good image. I would prefer underexposure because the details are preserved and will come out when exposure is compensated in post processing.
One more thing, interesting effects can be had when 'dragging the shutter'. This simply means firing the flash while taking a picture with a slow (around 1/30 or 1/60) shutter speed. This way your main subject will be properly illuminated, and due to the longish exposure time the background will be (hopefully) as well.