John Siracusa’s Front and Center app is interesting but has no appeal for me: I use Command-backtick to cycle between the windows of the current app, so I don’t care if they’re not in front. (I do this a lot with Safari, because I don’t like browser tabs.)