I wish I can find that one architectural photographer who takes bracketed shots with different WB.
For example inside the room with shade temp
The window where you can see outside with daylight temp.
The hallway with tungsten temp.
Then he combines all of them like HDR. The color is just awesome. Everything is correct exposure and color. He uses T/S lens. I wish I saved the link.
Oloneo PhotoEngine (link) does that kind of work very well indeed, and it is relatively cheap. It's a great piece of software for HDR/multiexposure, and I've switched to it from Photomatix. To get back to the OP's point, I usually shoot with a partial correction gel over my flash indoors, then white balance to the flash in post. This often helps with subject/background separation, and it gives something of the atmosphere of the ambient lighting. It's all personal taste, of course - there are times when you want uniform white balance and there are times when you don't. Anyone familiar with Chris Doyle's cinematography for Wong Kar-wai will have seen very effective mixed lighting, often copied now.