I can be a bit of a size switch myself (though more tiny leaning), but for me the difference tends to be in how I view shrinking versus growing. The idea of being shrunk sounds terrifying, and even as a tiny, I don’t ever fantasize about being shrunk. But I can find the idea of being already smaller (like a pixie or borrower) appealing and fun since there’s an element of having made it so far, ‘I’ know how to deal with the world and maybe just dealing with humans is novel, making that the point of focus, and dealing with cultural differences.
Where as growing does sound exhilarating. The outcome of being a spectacle and having the world after you, not really, but the Alice in Wonderland effect is such a fun spin on things. So I think its fun for the quick novelty, but not necessarily the long term, for me personally.