W.S.
J.,
I had a Roomba (it finally stopped after several years of regular use) - LOVE it for my ceramic and hardwood floors - I have a large ceramic tile area that's a real pain to keep clean - planning to get a new one just as soon as budget allows, mine was not so great on carpeting, but the newer ones are probably better.
It takes longer than if you do it yourself, but it's great because you can multi-task....your floor is being vacuumed while you are doing other things. It does make a bit of noise, and it can get 'stuck' on electric cords or area rugs, so you have to kind of keep an eye on it until you get used to where it might get stuck, but totally worth it in my opinion.
It comes with little devices that block it from going past areas you choose, so it can't fall down stairs etc....Picked up everything - dust balls, hair, play-doh crumbs, you name it! It can't hurt pets or little ones, it just gently 'bumps' into things and goes in a different direction.
I miss mine!