I think the take-home message for everyone is that with bike frames - especially aluminum and carbon - the tubes can really cause the sound to come from funny locations (like the bottom bracket) when the sound is actually coming from somewhere else. (This effect is even worse with the monocoque carbon frames these days as the carbon even seems to amplify the sound.)
Some of the best advice here came from the friend with 25 year's experience: rather than listening to where the sound is coming from, try to find out what activity seems to cause it (standing, sitting, sprinting, spinning, high power, low power, etc.) and start your elimination on what that reveals. I've even spent months searching for noises that I thought came from cranks or pedals which turned out to be creaking in the front fork dropouts!
Good luck!