We know that the intersection of two Sylow $p$-subgroups for the same prime $p$ is a prime power. Without more data, there is really nothing more to say. In fact, for any integer $n \geq 1$ we can find a finite group $G$ with the following properties:
- The Sylow $p$-subgroups of $G$ have order $p^n$.
- For any $0 \leq i \leq n$, there exists Sylow $p$-subgroups $P$ and $Q$ such that $P \cap Q$ has order $p^i$.
To construct such $G$, first let $q$ be a prime such that $q \equiv 1 \mod{p}$ and $q > p$ and $q > n$. The existence of such $q$ follows from Dirichlet's theorem.
Let $T$ be the nonabelian group of order $pq$. Define $G = T \times T \times \ldots \times T$, where $T$ appears in the direct product exactly $n$ times. Now $T$ has exactly $q$ Sylow $p$-subgroups, so let $P_1, P_2, \ldots, P_n, P$ be distinct Sylow $p$-subgroups of $T$. Let
\begin{align*}
Q_0 &= P \times P \times P \times \ldots \times P \\
Q_1 &= P_1 \times P \times P \times \ldots \times P \\
Q_2 &= P_1 \times P_2 \times P \times \ldots \times P \\
\ldots \\
Q_{n-1} &= P_1 \times P_2 \times P_3 \times \ldots \times P_{n-1} \times P \\
Q_n &= P_1 \times P_2 \times P_3 \times \ldots \times P_{n-1} \times P_n
\end{align*}
Now each $Q_i$ is a Sylow $p$-subgroup of $G$ and $|Q_i \cap Q_n| = p^i$ for all $0 \leq i \leq n$.