Revolt city, but I guess it's already changed.
Change civic seem too complicated for too little gain.
Spread culture seem simple to implement and can be very, very nasty.
For city improvement destruction, if not in a space race or culture race, I tend to believe that they should mainly / only destroy production building like forge and factory. They are rather costly, and destroying them is really a pain. And it's ALWAY a pain : if it's a prod city, then it's painful obviously, but if I had some factory on a cottage city, destroying it seem really, really nasty because of the long time needed to have it again and the difficulty to build stuff like observatory, university or bank whithout prod building or whip.
Destroying, for example a granary OTOH is random : not having a granary is nasty if I'm in my whiping infra phase, but in a well developped city it may do next to nothing. Happiness building seem to be too difficult compared to spreading unhapiness directly.
Destroying advancement on a wonder coveted by the AI could be a good improvement, but I don't know if it's possible at all, never tried. It may be the single most annoying thing an spy can do to me, especially in end game on stuff like 3-george dam.