Pretty much all of my sims are library sims because of the lot trait, and the programming for librarians has always been ridiculous. They have been this way since the beginning of the game. If you want to see how astonishing the AI is in this game, this is where it shines. And I don't mean that in a good way.
I always make a break room somewhere for my super study sims, with a fridge, counter, shower, and bed. It's insane how the librarians become obsessed with it. They are way beyond obsessed with making food and leaving it everywhere. Cleaning it up, not so much. They make food obsessively, then leave it everywhere, then start whining about lonely they are, then start kicking stuff in distress and pestering people. Then they start obsessing about food again, and lather rinse repeat until they fall asleep on a bench or loveseat somewhere. Meanwhile, those books scattered over the library amidst all of the spoiled food? Who cares! Not the librarian!
And it always turns into a freak show for celebrities too. Who knew that place filled with dusty old books was such a great hotspot for celebrities and their entourages of paparazzi and fainting fans. Bjorn Bergesen shows up to play chess, and he's a celebrity, and the whole place goes insane. Then Dirk walks in behind him for who knows what reason. Good luck trying to walk your sim through the mad throng to the bathroom. Might as well take a nap.
The AI in this game has been it's own worst enemy from the beginning, and is only getting worse. It would be nice if something in this game would ever be logical or reasonable, but that always seems too much to ask. Of course the price they want us to pay for this experience is never too much to ask. It's something that I continue to be frustrated with when it comes to this franchise. And as long as the librarians keep reminding me of it, I always will.
We are not getting the experience we deserve with this game, and librarians are the poster children for that.