[jonnythan]

I must be missing something, because I see virtually no noise whatsoever in that image.

Camera phones are the worst possible way to take low-light pictures - they have the smallest sensors, smallest apertures, and worst optics. Low-light photography is incredibly difficult hardware-wise. Many people spend $500 on those big bulky 15x-zoom cameras and are still frustrated when they can't take a decent picture inside. These people don't usually notice how bad it is because their cameras have flashes - but if they try to turn the flash off and get a decent picture, they are generally always disappointed by blurry pictures and noise.

DSLRs tend to take better inside pictures, but the main reason is that they have huge sensors that can be cranked to ISO 1600 or higher with relatively little noise.

All that said, there's not much you can do to take better indoor pictures. You're pretty much stuck with blurry images, noise, or both. That applies equally well to the Hero and iPhone (again, I mention the iPhone because it has what is probably the best phone camera out there). It also applies to digital cameras, but their saving grace is that they usually have a bright flash.