I love my CDP-100. I've had it for about 18 months and it's been a great investment. We have a tiny house with lots of nooks and crannies, but nowhere for a proper upright or even a larger sized digital piano. I looked at a Clavinova but even that, with its relatively small profile, would have been a tiny bit too wide for the space we wanted to put it in.
Good things about the CDP-100: It has a good sound, is very similar in response to a normal piano (not exactly the same, but then nothing ever will be), it's a hell of a lot cheaper than other entry models and the set up means that it takes up very little space, given that the depth of the instrument isn't that much more than the length of the keys. It has a solid music holder too. And it should work well with any basic stool or even a normal height dining room chair.
Bad things - the pedal it is supplied with takes a lot of getting used to, it doesn't come with its own stand when bought from most suppliers (although it will sit quite happily on a basic universal type stand, the Casio stand is a lot sturdier so worth the extra investment).
But those are little gripes about what is, after all, an excellent entry level digital instrument. Perfect for the intermediate and beginner alike, and possibly even an advanced player (I have a couple of very good pianist friends who both liked the feel of it). If you don't have much space, this IS the digital piano for you.