At DTW the best 'lounge' can be the lobby and restaurant at the Westin, as long as their dedicated security line to return to the terminal is open. Quiet, comfy, and frequently very empty.
Years ago they would sell you a cheap day pass for the fitness center, but I haven't tried that recently.