My cat didn't like that all all, it was very hard to get him to use it. But probably it was just my cat, I've heard other cat owners say it's good. But I recommend to just get one of them to try it out with your cat before getting lots.
My experience is that telling your neighbors that cats help keeping mouse population never helps :( But I guess it depends on how much of a mouse problem there is in the area.
My cat cried a lot when he came to our home when he was a kitten, but it just took a couple of weeks for him to adapt, then all was ok. However, the same thing happened when we moved a couple of years later. So my guess is that it had to do with the change of environment most of all.