How do I make Command+Tab only bring the active window for an application to the foreground?
Apple's solution, like it or not, is to use Exposé or Mission Control (Lion) to switch between windows. ⌘ + tab is considered an application switcher.
There are third party solutions to change this behavior, but I don't have experience with them. There is some discussion about these solutions on this Super User question.