10:22 PM
no - for most groups, there's no Moore spectrum for the constant Mackey functor
in fact, for any nontrivial group
this was shown to me by @Tyler
oh, I think I might have misinterpreted the question - you're talking about homology with coefficients in the constant Mackey functor, so the sphere is a Moore spectrum from the constant Mackey functor in this sense
I strongly suspect the answer is still no
I don't think the constant Mackey functor has well-enough behaved homological algebra for this kind of thing to hold