Now forgetting down to spectra with a $C_p$-action (i.e., the homotopy theory of $C_p$-diagrams in spectra or, alternatively, the $\infty$-category $\mathrm{Fun}(BC_p, \mathrm{Sp}))$ and taking rational homology we obtain an isomorphism of two graded $\mathbb{Q}$-vector spaces with $C_p$-actions. This shows that the permutation $C_p$-representation $\mathbb{Q}[C_p]$ is in the localizing subcategory generated by the trivial representation (since $p$ is odd, the homology of the representation spheres is always a shifted copy of $\mathbb{Q}$ with a trivial action). We are unable to buildNow we have a cofiber sequence $$\mathbb{Q}[C_p]^{C_p}\to \mathbb{Q}[C_p]\to \mathbb{Q}[C_p]/(\mathbb{Q}[C_p]^{C_p}).$$ Now $\mathbb{Q}[C_p]$ is in the localizing subcategory generated by trivial representations if and only if the cofiber is. However the only map from a trivial rep to the non-trivial action from trivial onescofiber is 0 (note this would fail in characteristic $p$), so this isthe cofiber fails to be in the localizing subcategory generated by the trivial reps and we obtain a contradiction.
I do not have a good answer for the remaining questions. For general groups there are many indices in the $RO(G)$-grading. Even if you pass to the smaller $JO(G)$-grading (which is what you get when you quotient $RO(G)$ by the equivalence relation $V\sim W\iff S^V\simeq S^W$), I would think it would be difficult to convey the data concisely. For cyclic $p$-groups (and perhaps more), one can probably get at the $RO(G)$-graded groups for an Eilenberg-MacLane spectrum associated to a Mackey functor. Ferland-Lewis and Lewis have relevant calculations. I imagine there are more calculations when $G=C_2$.