A full understanding of this issue requires a theory of integration over probability distributions, not just functions. However, even in such an abstract theory it's possible to visualize the integrals as areas under curves. The universal principle is that in any "reasonable" theory of integration, it should be possible to integrate by parts.
Consider the usual integral formulation of an expectation of a function $S$ for a distribution $F$ with density function $f(x) = F^\prime(x).$ This is given by
$$E_X[S(X)] = \int_{-\infty}^\infty S(x) f(x) \mathrm{d}x.$$
Let's suppose $S$ has two properties, neither of which severely limits the theory:
$S$ is differentiable and
The limiting values of $S(x)F(x)$ at $-\infty$ and $S(x)(1-F(x))$ at $\infty$ are zero. (This is equivalent to assuming $S$ has an expectation.)
The first enables us to apply integration by parts while the second enables us to cope with the infinite limits of integration. To do this, we will need to break the integral into two at some convenient (finite) value; for simplicity, let's break it at zero. In the negative region, write $f(x) = F^\prime(x)$ but in the positive region, $f(x) = -\frac{d}{dx}(1-F(x)).$ Integrating each integral separately by parts gives
$$\eqalign{
E_X[S(X)] &= &\int_{-\infty}^0 S(x) f(x) \mathrm{d}x + \int_0^\infty S(x) f(x) \mathrm{d}x \\
&= &\left(S(x)F(x)\left|_{-\infty}^0\right. - \int_{-\infty}^0 S^\prime(x) F(x) \mathrm{d}x\right) + \\&&\left(-S(x)(1-F(x))\left|_0^\infty\right. + \int_0^{\infty} S^\prime(x) (1-F(x)) \mathrm{d}x\right) \\
&= &\int_0^{\infty} S^\prime(x) (1-F(x)) \mathrm{d}x - \int_{-\infty}^0 S^\prime(x) F(x) \mathrm{d}x.\tag{*}
}$$
We may picture this process by drawing the areas under consideration, ignoring the factor of $S^\prime (x)$ for the moment:
The left image graphs the density function $f,$ the middle graphs the distribution function $F,$ and the right graphs the function $F$ for negative values of $x$ and $1-F$ for positive values. When you scale the heights of the right hand graph by the values of $S^\prime(x),$ the expectation is the corresponding (signed) area under the curve.
Turn now to a distribution without a density, such as a discrete distribution. Here are corresponding graphs for a distribution that puts probability $1-p$ on the value $-1$ and $p$ on the value $1$ (a Rademacher distribution):
(The plot of the density $f$ is omitted because, although it exists as a density, it does not exist as a function and therefore has no graph.)
As an example of how $(*)$ works, let's compute an expectation for this distribution. The integrals are finite because when $x \lt -1,$ $F(x)=0$ and when $x \ge 1,$ $1-F(x)=0.$ Thus:
$$\eqalign{
E[S] &= \int_0^{\infty} S^\prime(x) (1-F(x)) \mathrm{d}x - \int_{-\infty}^0 S^\prime(x) F(x) \mathrm{d}x \\
&= \int_0^1 S^\prime(x)(1 - (1-p)) \mathrm{d}x - \int_{-1}^0 S^\prime(x) (1-p)\mathrm{d}x\\
&=(1 - (1-p))S(x)\left|_0^1\right. - (1-p) S(x)\left|_{-1}^0 \right. \\
&= (1-p)S(-1) + pS(1).
}$$
This is the sum of the values of $S$ (at $\pm 1$) multiplied by their probabilities. A generalization of this calculation shows that this integral is precisely a sum of values multiplied by probabilities for any discrete distribution:
When $F$ is a discrete distribution supported at values $x_1,x_2,x_3, \ldots,$ with corresponding probabilities $p_1, p_2, p_3, \ldots,$ then the expression $(*)$ is $$E[S(X)] = \int_0^{\infty} S^\prime(x) (1-F(x)) \mathrm{d}x - \int_{-\infty}^0 S^\prime(x) F(x) \mathrm{d}x = \sum_{i=1}^\infty S(x_i)p_i.$$ The integrals can be interpreted as signed areas, even though $F$ has no density function. Indeed, when $S^\prime$ is piecewise continuous, the integrals can be interpreted as Riemann integrals.