For a supergravity theory not to have particles with spin greater than 2, all books state that $Q\leq 32$, where $Q$ is the number of fermionic supercharges and for a given dimension $D$ it's related to the number of supersymmetries $\mathcal{N}$ through the number of components of the fundamental spinors in that dimension, $C$ as $Q=\mathcal{N} C$.
Naively, I would expect each supercharge $Q$ to raise or lower the spin of a given particle by $1/2$, as it does in the 4 dimensional case, but I suspect this is not the case in different dimensions (though all the books I have read are pretty confusing, just analyzing $D=4$ in detail using the chiral properties in that dimension and then hand-waving their way to higher dimensions).
If each of the $\mathcal{N}$ supersymmetries could be used once and only once to raise the spin of the states, then I would expect the limit to be $\mathcal{N} \leq 8$ instead of a bound on $Q$, but this is not the case.
According to one of my professors, $Q=32$ is just the consequence of wanting $\mathcal{N}=8$ at the most in 4 dimensions, where $C=4$, so that we can compactify the higher dimensional theory and obtain an acceptable model for our world.
However, the $D=11$ supergravity should only include the graviton in that case, right? And $D=10$ theories would only have the graviton and $\mathcal{N}$ gravitinos, which is not true. So what's the right justification for $Q \leq 32$?