What's on will depend when you are coming.
August is bedlam with the Fringe festival. Book accomodation asap though as the city cells out.