The Banach space dual of $L^p$ is $L^q$, where $q=\frac{p}{p-1}$, but I don't really understand the motivation behind this. In particular, I find it kind of surprising that the only $L^p$ space whose dual is isomorphic $L^p$ is for $p=2$. So I guess I'm wondering what's so special about the number 2 in the context of $L^p$ spaces, or rather, where the formula $\frac 1 p + \frac 1 q = 1$ originally comes from / is motivated from.
Edit: I understand that $p=2$ gives the only Hilbert space, but I'm wondering whether there's any sort of deeper reason behind the relationship between $p$ and $q$ --- does $\frac 1 p + \frac 1 q = 1$ arise naturally out of integration theory in a more satisfactory way than "it just happens to be like that"?
I elaborate on a remark in one of the other answers.
Consider a measure space $(X,\mathcal{M},\mu)$ which has sets of arbitrarily small measure and sets of arbitrarily large measure. (Here I think of the Lebesgue measure on the real line.) Let $1 \leq q < \infty$ and choose
$$g \in L^q \setminus \bigcup_{p \in [1,\infty), p \neq q} L^p.$$
This is messy, but doable. $f \in L^1$, but $f \not\in L^p$ for all $p > 1$ handles the case $q=1$, and given my assumption about the measure space, you can do something similar to get higher $q$. Let $\phi(f) = \int_X fg d \mu$.
Now let us consider a function in $L^p$ which makes $\phi(f)$ "large". Specifically we take $f=|g|^{q/p} \text{sign}(g)$. The point is that this is automatically in $L^p$ since $g \in L^q$, but it is also big exactly where $g$ is big.
Now if $\frac{q}{p} + 1 = q$ then $\phi(f)=\| g \|^q_{L^q}$. Yet otherwise $\phi(f)$ is infinite! That is, $\phi$ is only bounded on $L^p$ if $\frac{1}{p}+\frac{1}{q}=1$.