A very strong indoor light source can also produce lens flare...but that's rare. Having one on when using flash can increase the chance of a shadow in the shot, depending on the position of the flash. But I would imagine that most shooters who use them indoors just leave the hood on for protection.
Some Gear: Nikon D700; Nikkor AF-S 50 f/1.4 G; Nikkor AF-S 24-85 3.f/5-4.5 G ED; Tamron 28-300 f/3.5-6.3 VC; Nikon SB-800; Velbon Maxi-F; Canon Pixma Pro 9000; Canon S3IS, Canon SD500; Epson 4990; Epson P5000; Wacom Intuos 3
Main Software: Capture NX2; Adobe PhotoShop CS2; Corel Paintshop Pro X2 Ultimate
Sold: Canon XT/350D, EF 24-105mm f/4 L IS, EF 100mm f/2.8 Macro; EF-S 10-22mm f/3.5-4.5, Sigma 18-200 OS; Canon ET EF 25II; Kenko Pro 300 DG, Canon 430EX, Canon BG-E3.