As an example of limits cutting out solutions to equations think of equalizers or pullbacks in $\mathsf{Set}$. Do it now, before reading on. This is the sort of example that you need to have at your fingertips.
In any complete category $\mathcal{C}$, the limit of a functor $F: \mathcal{I} \to \mathcal{C}$ can be computed as the equalizer of two maps $\prod_{\alpha \in \mathbf{Mor} \mathcal{I}}F(\mathrm{dom}\alpha) \overset{\to}{\underset{\to}{}} \prod_{i \in I} Fi$. In $\mathsf{Set}$, the two arrows are functions in $|\mathbf{Mor}\mathcal{I}|$ variables, and the equalizer is the set of all solutions to setting these two functions equal to each other.
Now remember that the categories you're thinking of are concrete categories, usually admitting a limit-preserving (even right adjoint) functor to $\mathsf{Set}$. So their limits are calculated in the same way, with some bells and whistles to specify the structure forgotten by passing to the underlying set.
Of course, these kinds of intuitions have their limitations -- most obviously, by passing to the opposite of the category you're considering, you switch limits and colimits.
Even in perfectly ordinary settings, sometimes the "cutting-out-by-equations" notion is not the easiest way (for me) to think about limits. For instance, consider the $p$-adic integers $\mathbb{Z}_p = \varprojlim \mathbb{Z}/p^n$ where the limit is taken in $\mathsf{Ab}$ over the obvious chain of quotient maps $\dots \to \mathbb{Z}/p^{n+1} \to \mathbb{Z}/p^n \to \dots$. The cut-out-by-equations description describes this as the subgroup of $\alpha \in \prod_n \mathbb Z/p^n$ such that for each $n$, $\alpha_n = p\alpha_{n+1}$. I tend to think of this as the coordinates $\alpha_n$ being "glued" together -- somehow the individual elements of the limit are glued together whereas in a colimit it's the whole space itself that's been glued together. This can even be seen in the case of pullbacks in $\mathsf{Set}$: an element of the pullback can be thought of as "glued together" from elements of the two upstairs sets, "glued together" by an equation between them downstairs. I'm not quite sure if this can be explained in some categorical way. Maybe (homotopy?) type theory could help to understand this.
I also tend not to think of $\mathbb Z_p$ as being "cut out" of $\prod_n \mathbb{Z}/p^n$ even though it is: I think the reason is that the latter space is so huge and $\mathbb{Z}_p$ is so small -- it is a subspace of very high codimension. I suppose this is no different from the fact that I don't usually explicitly think of a CW complex as a quotient of the coproduct of all its cells.