It's good for both cases, isn't it? It's usefull for informing your users what is happenning.

> but then wouldn't you just want to show your users a 404 with a nice reason why the content has gone.

A 451 with a nice reason why the content was gone is better.