I can't think of many 'content bots' on nostr actually. But they can be kind of interesting / fun.

Fiatjaf's emperor's new groove thing
nostr:nprofile1qqsqhkj4nlklu9hqnxj33fxhzhlqlzzay7wcsqam4wrzz96d9lslp4qpr9mhxue69uhhyetvv9ujumt0d4hhxarj9ecxjmnt9ur9m80y
Some avgregated news RSS things
🤔