When must Cassandra be restarted? for which procedures? Anybody got something similar to a listing?

for instance: - when altering a column family definition.

Virtually just upgrades. Schema changes, cache configurations, even subsystems such as the snitch can be transformed with no restart.