The following arguments are taken from the fantastic book "Cauchy-Schwarz Masterclass" written by Michael Steele.
At first, we take a look at a rather similar inequality which we will show to be very close to Cauchy-Schwarz.
For the case of $n=1$, we consider
$$\tag{elementary} xy \leq \frac{x^2}{2} + \frac{y^2}{2}.$$
If we replace - as Steele does on page 19f - $x$ and $y$ with its square roots and multiply by $4$, we arrive at
$$ 4 \sqrt{xy} < 2 \, (x + y), \quad \text{for all nonnegative } x \neq y.$$
The equality holds when $(x-y)^2 = 0$, which is excluded now.
Let us fix $a$ and $b$ as side lenghts of a rectangle such that $A = ab$. Considering all arbitrary side length $x$ and $y$ such that $A = ab = xy$, we might realise that the left hand side is the perimeter of the square with length $s = \sqrt{xy} = \sqrt{ab}$. The right hand side is the perimeter of all other possible rectangles with $x$ and $y$ as side lengths.
The generalisation from $xy$ to $x\cdot y$ is now very close. For $n=3$, we can interprete the statement that among all boxes in $\mathbb{R}^3$, the cube is the one with largest volume given a fixed surface area.
So, the elementary inequality given above is easy to interpret. But how to arrive at Cauchy-Schwarz?
First, Steele on page 5 adds up $n$-times the elementary inequality for $x_i$ and $y_i$ to arrive at
$$ \sum_{i=1}^n x_i \, y_i \leq \frac12 \, \left( \sum_{i=1}^n x_i^2 \, + \, \sum_{i=0}^n y_i^2 \right). \tag{additive}$$
If we take a look at normed vectors, namely $\tilde{x_i} = \frac{x_i}{\sqrt{\sum_{i=0}^n x_i^2}}$ and $\tilde{y_i} = \frac{y_i}{\sqrt{\sum_{i=0}^n y_i^2}}$, we are able to convert the additive bound into the Cauchy-Schwarz inequality as
$$\tag{CS} \frac{\sum_{i=1}^n x_i \, y_i}{\sqrt{\sum_{i=0}^n x_i^2}\,\sqrt{\sum_{i=0}^n y_i^2}}=\sum_{i=1}^n \tilde{x_i} \, \tilde{y_i} \leq \frac12 \, \left( \sum_{i=1}^n \tilde{x_i}^2 \, + \, \sum_{i=0}^n \tilde{y_i}^2 \right) = 1$$
So, as the Cauchy-Schwarz inequality is recovered from the elementary inequality for just very special choices of $x_i$ and $y_i$. But now we got a neat intuition at hand and we can imagine why Cauchy-Schwarz will appear pretty often - as it is closely related to the fundamental perimetrical inequality for boxes and cubes.