The main game is really good.
Avoid the DLCs. All three of them are filled with bugs, confusing level design, horrible checkpoint placement requiring you to retry frustrating parts over and over again. When you die to a bug, it just makes it all the more frustrating when you have to go back and do the last 5-10 minutes over and over again. They don't progress the story very much and are more frustrating to play than anything.
They're also filled with one off mechanics that aren't introduced to you, expected to be used to solve a puzzle without a tutorial on the new mechanic and then thrown to the side and never used again. The Residence DLC goes so far as to change the game's control scheme in a certain context (which I won't spoil here) without so much as letting you know.
Normally you point the flashlight around the room with the right stick (not sure about KB+M controls, only used a controller), moving the stick up points the flashlight up towards the ceiling. In this new context, the right stick rotates the flashlight 360 around the character instead of vertically. This isn't explained in any fashion during the scene and worst of all, not realizing there's a new control scheme will result in you dying repeatedly and not understanding why or what to do. And the second this new mechanic is done
(When you finally manage to defeat all the annoying little shadow children) , the controls go right back to normal, again without informing you they'd been changed in the first place.
The DLCs were so bad that it muddled my recollection of the main game as well, having convinced myself that I didn't like Little Nightmares at all, which is far from the truth.