Let $\mathcal{C}$ be a presentable category, and let $S$ be a set of objects such that $S$ generates $\mathcal{C}$ under colimits, i.e., such that the smallest cocomplete subcategory of $\mathcal{C}$ containing $S$ is all of $\mathcal{C}$. Under what conditions is it true that for every object $x \in \mathcal{C}$, there exists a functor $f: \mathcal{I} \to \mathcal{C}$ whose image is contained in $S$ and whose colimit is isomorphic to $x$? This is true for example if $\mathcal{C}$ is a presheaf category and $S$ the canonical set of generators (the representables). I suspect the answer is no in general, but I don't know how to construct an example.
I am also interested in the analogous question for presentable $\infty$-categories.
Edit: After posting this question, I became aware of Mike Shulman's answer here which addresses the same question with the counterexample being the category of compact Hausdorff spaces. But is there a natural presentable example that one might expect to come across (some type of structured sets, for instance)? I'd like to get some intuition for this phenomenon.