There is an implicit notion in this question that condensed mathematics was specifically constructed to formalise some intuition about how to work with 'topology-like' structures. This is historically inaccurate: the usefulness of condensed mathematics was in some sense discovered by accident, as a 'trivial' case of some other construction (the pro-étale topology).
While it might still be possible to give a post hoc justification, let me focus instead on the historical motivation. This is not what you ask, and I apologise if you know all of this already. However, the pro-étale topology is something that is intuitive and tries to formalise a specific idea.
The starting point is, roughly speaking, building universal covers in algebraic geometry. If $X$ is a smooth complex algebraic variety, then its universal cover $\widetilde X \to X$ need not be a map of algebraic varieties: for instance, the universal cover of $\mathbf C^\times$ is the exponential map $\mathbf C \to \mathbf C^\times$ (in this case, $\widetilde X$ happens to be an algebraic variety, but that also fails in general). However, a theorem first proven in SGA$4_{\text{III}}$ (as far as I can tell) says that every finite covering space of a complex algebraic variety is again a complex algebraic variety (and the map is algebraic). This is called Grauert–Remmert in SGA, and in later writings is often informally called the Riemann existence theorem. For instance, the unique connected degree $n$ covering of $\mathbf C^\times$ is the $n$-th power map $\mathbf C^\times \to \mathbf C^\times$.
For a long time, people were content with this: this observation (plus a lot of theory) was enough to define étale cohomology: a way to construct (something isomorphic to) singular cohomology $H^i(X,\mathbf Z/n\mathbf Z)$ defined purely by algebraic geometry (in particular, it can be done for varieties in positive characteristic as well). With a limit procedure, you can extract $\ell$-adic cohomology $H^i(X,\mathbf Z_\ell) = \lim_n H^i(X,\mathbf Z/\ell^n\mathbf Z)$ if you want cohomology with characteristic $0$ coefficients.
If you want a universal cover instead of just finite étale covers, you can take the limit, which is now a profinite cover. In algebraic terms, if the degree $n$ cover of $k[x,x^{-1}]$ (the coordinate ring of $\mathbf A^1_k \setminus \{0\}$) is given by $k[x^{1/n},x^{-1/n}]$, then the pro-étale universal cover is given by $k[x^{1/\mathbf N},x^{-1/\mathbf N}]$, the union of all of these. The map $\widetilde{\mathbf C^\times} \to \mathbf C^\times$ is then Galois with group $\hat{\mathbf Z}$ (where $\widetilde{\mathbf C^\times}$ is a scheme but not of finite type over $\mathbf C$, so not an algebraic variety). Likewise, the pro-étale universal cover of $\operatorname{Spec} k$ is the spectrum of a separable algebraic closure $\bar k$ of $k$, so this recovers classical profinite Galois theory. (All of this could have been done a long time ago, but it was Scholze's work in $p$-adic geometry that brought this to the attention: you're somehow forced to think about pro-étale covers because a $p$-adic analytic variety is only pro-étale-locally perfectoid, not étale-locally.)
Then it turns out that taking the pro-étale topology fixes some of the technical issues of working with $\ell$-adic étale cohomology: you can now really take the cohomology of the sheaf $\mathbf Z_\ell = \lim_n \mathbf Z/\ell^n\mathbf Z$, whereas in the étale topology you have to take the limit after taking cohomology, which leads to all sorts of complications.
Finally, condensed mathematics is the pro-étale topology on the spectrum of an algebraically closed field; in other words, a point. So all the algebraic geometry disappears and you're "just" doing topos theory. I think it was a well-known principle that internal abelian group objects (or group objects, groupoid objects, category objects) in a topos is better behaved than internal group objects (...) in an arbitrary category. So from this point of view, the usefulness of condensed mathematics is explained by the fact that it is a topos in which topological spaces embed fully faithfully. (Insert set-theoretic caveat; in practice it is usually enough to work with $\kappa$-condensed for some cardinal $\kappa$, so that you really get a topos.)
If that is your point of view, you could also take any Grothendieck topology on topological spaces for which representable presheaves are sheaves (such a topology is called subcanonical) and use that as the basis for your theory. This is not so far from the truth: one way to obtain condensed sets is by endowing compact Hausdorff spaces with the coherent topology: coverings are finite families of jointly surjective maps of compact Hausdorff spaces $\coprod_{i=1}^n X_i \twoheadrightarrow X$. To connect this with the profinite theory, observe that every compact Hausdorff space is a quotient of a profinite space (for instance, the Stone–Čech compactification of the underlying discrete space), so profinite spaces (or even extremally disconnected spaces) form a basis for this Grothendieck topology.
(Actually, I have no idea what happens if you put a different Grothendieck topology on a suitable subcategory of topological spaces; in principle there could be many different theories here, but I don't know how to tell a priori which ones will tell you something meaningful.)