It isn't so much rooms that have it, than anywhere with a speaker set-up. The sweet spot is just the focal point between the speakers, usually a pair, sometimes a whole set up.
There are some people using computers to make the sweet spot move with the listener. It would have driven Sheldon nuts!