Here's a few examples:
1. I follow a few photographers that I greatly admire. Some of their best work is on Twitter. With super-follows, I can support these artists and get exclusive posts for things like gear reviews, etc.
2. I follow a lot of economists/scientists that often have really interesting insights. Noah Smith, Tyler Cowen, Ezra Klein, Scott Manley, to name a few. I'd happily pay a couple dollars a month for more in-depth content by them on Twitter.
3. I also follow some interesting writers and creators, like Craig Mod, Hundred Rabbits, and Kyle Chakya. I could see myself paying them a couple bucks a month if enough of their content was offered that way. They are also people I really respect, so I'd be happy to support them.