For me, after watching Matilda, I always wanted telekinesis. I think the movie really resonated with me for other, more substantial reasons, but I remember as a kid wishing that one of my high-stress situations would let me get those powers.
Edit - Fun fact: I had a sibling who stopped believing in God because they prayed for Wolverine claws as a kid, but didn't get them.
Super strength since I wanted to help people but didn't know how to other than doing stuff they couldn't. Physical things seemed easiest since I didn't really know how to do much else.