Consider that becoming a Stand user meant that I would either have to born naturally with it or piercing myself with an alien arrow that has a 50/50 chance of killing me or giving me Stand ability, realistically speaking, no I would rather not prefer to become a Stand user unless I am pressured to do so.
Becoming a Persona user is simple, you are either born with the ability or being experiment on like in Persona 1 to Persona 3, facing your dark self and accepting it in Persona 4, and having a rebellious resolve in Persona 5. Plus seeing how differently can Persona ability be achieved, it is safe to assume that in the future, gaining Persona ability could be even easier.
Sure, having a Stand ability that can shoot out bubbles or shift reality sounds cool, but the moment I acquire Stand ability, I would enter into the world of bizarre and I can very well say that I will be the one who dies first.