I've been here a couple times and love it! The building is a world-class architectural gem! The space is a work of art itself. It's not The Met or The Art Institute of Chicago, but it a still a cultural gem (on a smaller scale).
The have some amazing temporary exhibits. I went for the Viva Moschino! fashion exhibit and it was amazing. Moschino was was so ahead of his time. The clothes are works of art! The exhibit was incredibly well done! I went to the Halton/Warhol exhibit last year which was equally inspiring.
The permanent exhibits are on two floors. The 4th floor houses the American and Contemporary Art. The contemporary art collection is a bit fragmented and thin. The showpiece is the massive Kehinde Wiley portrait. It is a "must-see!" The Romare Bearden collection is a must.
The museums real niche is Crafts + Design on 3. The galleries are arranged by material (glass, metal, wood, jewelry, etc). The collection is stunning and impressive. Go!
Nice gift shop on the street level and members get a discount at Halcyon restaurant on mezzanine level (one of Charlotte's best).