Cecily Brown is among the most expensive living female painters and this exhibition shows exactly why