For me, the big success in terms of payment came by chance - someone read a couple of my stories in 365tomorrows (a non-paying market), and on that basis contracted me to write weekly stories containing background lore for an NFT project. That lasted about a year before the bubble burst, but was a nice little earner. Other than that, I think the most I've been paid for a story is about US$5.