It is only useful if you have a bunch of stuff sitting in front of you window and you are able to tilt another window on the other side of the house but its really not that big of a deal.

many houses these days are built too air tight,

No such thing. You just have to make sure you use a proper ERV setup.