Sophia,
Yes, I took the water-drop picture with my G6. It took a lot of shots to get the timing and manual focus just right, but in the end I was happy with the results, and I learned a bit in the process.
The internal flash can easilly overexpose your subject--I generally avoid it, but I also generally shoot outdoors, where I don't need it. There are a number of ways around that.
For the close-up, did you enable macro mode? There's a button on the upper left of the back of the camera with a flower-icon on it. That toggles the auto-focus between trying to focus on items 2 feet away or less, and 2 feet or more away. I don't remember if Canon's DSLRs require you to toggle in and out of macro mode or not.
Quick question, when you're pressing the shutter release, are you pressing it all the way, or are you pressing it a little bit to the first feeling of resistance, waiting for the square focus indicator on the LCD or the LED next to the viewfinder to turn green, and then pressing it the rest of the way to take the picture? If either indicator is orange, the camera hasn't found an acceptable focus. If you're very close, you may need to enable the macro mode.
Also, when you half press the shutter release, take a note of the shutter speed indicator on the lower left of the LCD--is it faster than 1/60th? Is there a "camera shake" icon in red to the left of that? If you have the flash off, and you're shooting indoors, often the metering will set the shutter speed to something slower than 1/60th, which would require a very steady hand, or a tripod in order to eliminate visible blur in the photo.
Also, try enabling manual focus. I think that's on the left side of the camera; it's labeled MF. Once it's on, use the scroll wheel in front of the shutter button to change the focus--I find myself using this a lot, and based on your film background, you may also prefer it. Note the distance indicator along the right side of the LCD, for a rough guide.
Again, I love my G6, but I'm not totally convinced it's the camera that will make you a happy photographer, and that's the bottom line. Granted, I also have some questions about how you'll like the XT after the oooh-ahhh factor wears off 
Edit:
Your brother's concern about handing a DSLR to a stranger is valid, though if you put it in auto mode, it should do everything for them--they just need to frame it without chopping your feet out of the picture, and I'm afraid that's a toss-up, no matter what kind of camera they're used to! Personally, I'd be more nervous about handing my expensive, heavy DSLR to a complete stranger, esp. one who is used to a camera that weighs as much as a deck of cards. Heck, I don't hand my G6 to strangers either, but mostly that's because I carry a miniature tripod with it, and then I use the IR remote to shoot pictures of myself with friends/family.