There are many stories where big people get cursed or otherwise bothered by the wee folk. But I just love the aesthetic of tiny people going about their business. For example, I like
Little witch Hazel
One-inch boy
The borrowers/Arietty
Polly pocket
And of course Hans Christian Andersen’s Thumbelina!
I’ve also read the Wee Free Men by Terry Pratchet and while it’s worth it for the laughs, it’s not the vibe (cute)
There are some books about small animals I love, though I am looking for small *people*. I really like
Mrs. Tittlemouse and other stories by Beatrix Potter
The Brambly Hedge Mice
by DoubleDragonsAllDown