CmdrGoob said:
I also hear that doing a great work will end the civil unrest in a newly captured city
That was changed in BtS (iirc).
But while we're on the subject of culture bombs and their potential uses...
In one rather memorable game I popped an unlikely GA whilst conquering Monty, and used it to culture bomb his capital. Thus, I secured most of his land and resources, without having to keep a load of his crappier cities.
Similarly, on several occasions I've dropped a culture bomb in the new world on a Terra map, and so grabbed several cities-worth of land and resources without incurring those nasty colonial maintenance costs, or having to ship more settlers over.
Also, a while back, I did some experiments with an early culture bomb gambit using a Philosophical leader:
Oracle->CoL asap, run Artists via Caste System, settle and culture bomb second city, settle and culture bomb third city.
It isn't reliable (thanks to the priest GPP from the Oracle) or, in the vast majority of cases, especially helpful. But there were a couple of starts where I managed to block off most of a continent for myself, pretty much guaranteeing a win if I had played on.
Finally, I suppose there might be times when the instant 60% cultural defence could come in handy, though I can't say ever had it happen in one of my games.