Since you can estimate slope of simple linear regression using correlation coefficient
$$ \hat {\beta} = {\rm cor}(Y_i, X_i) \cdot \frac{ {\rm SD}(Y_i) }{ {\rm SD}(X_i) } $$
It is not true that there are cases when regression could be appropriate where correlation is not. The only such case where the statement could make sense is if you are talking about multivariate relations to account for, but still, you can use partial correlation as well in such cases.
As noted by whuber, regression is much more sophisticated model that gives you more information then correlation alone, but the difference is not about appropriateness, but about their utility and the fact that regression provides additional information.