The changing art exhibits at SFO are always interesting. We take our time looking at the displays and really enjoy them. They are scattered throughout the D terminal, some of the walkways, and the transit hallways between D and F. They may be elsewhere, but those are the terminals that we use regularly.
Now, the new "mood room" at SFO just seems bizarre to me. But we do use the various yoga rooms quite often.
There is also art at SAN, I think it's usually local artists.