LLMs in data pipelines enable all sorts of “before impossible” stuff. For example, this creates an event calendar for you based on emails you have received:

https://www.indexself.com/events/molly-pepper

(that’s mine, and is due a bugfix/update this week. message me if you want to try it with your own emails)

I have a couple more LLM-powered apps in the works, like next few weeks, that aren’t chat or code. I wouldn’t call them transformative, but they meet your other criteria, I think.