According to the Sims Wiki, Art Galleries attract sims with the Artistic trait, deters sims with the Can't Stand Art trait, and encourages sims to learn the Painting skill.
World: Appaloosa Plains
Name: Appaloosa County Historical Society
Size: 40 x 40
Cost: $271,803
World: Aurora Skies
Name: The Wallpaper Museum of Modern Art
Size: 25 x 50
Cost: $228,333
World: Barnacle Bay
Name: Goldbeard Galleon Gallery
Size: 40 x 40
Cost: $106,425
World: Bridgeport
Name: The True Modern Art Gallery
Size: 62 x 29
Cost: $270,947
World: Dragon Valley
Name: Heart and History Art Gallery
Size: 30 x 30
Cost: $229,277
World: France
Name: La Gallerie d'Art
Size: 64 x 64
Cost: N/A
World: Hidden Springs
Name: Paul A. Wilkes Natural Museum
Size: 30 x 30
Cost: $214, 675
World: Isla Paradiso
Name: Seaside Stuff Art Gallery
Size: 25 x 20
Cost: $138.393
World: Isla Paradiso
Name: Nautical Museum
Size: 26 x 26
Cost: $191,691
Name: Sunshine Art Gallery
Size: 20 x 50
Cost: $117,389
World: Lucky Palms
Name: Paint A Desert Art Gallery
Size: 50 x 50
Cost: $316,803
World: Lunar Lakes
Name: Aphelion Art Gallery
Size: 40 x 40
Cost: $214,311
World: Midnight Hollow
Name: Antiquity Art Museum
Size: 50 x 25
Cost: $229,187
World: Midnight Hollow
Name: Avant-Garde Gallery
Size: 40 x 20
Cost: $238,737
World: Monte Vista
Name: Museum D'Art
Size: 25 x 25
Cost: $292,892
World: Moonlight Falls
Name: Moonlight Falls Historical Society & Museum
Size: 40 x 40
Cost: $174,655
World: Riverview
Name: Octagon House: Historical Museum and Art Gallery
Size: 20 x 25
Cost: $177,856
World: Roaring Heights
Name: Community Art Gallery
Size: 30 x 20
World: Roaring Heights
Name: Downtown Museum
World: Starlight Shores
Name: Urbane Center for the Arts
Size: 45 x 45
Cost: $288,644
World: Sunlit Tides
Name: Oceanview Art Gallery
Size: 30 x 30
Cost: $143,227
World: Sunset Valley
Name: Sunset Institute of Modern Art
Size: 31 x 50
Cost: $233,743
World: Twinnbrook
Name: Curios Memorial Museum
Size: 30 x 30
Cost: $213,674
World: Store Venue
Name: Prism Art Studio
Size: 40 x 40
Cost: $493,968
Which is your favorite Art Gallery?