We've had various ones. Started off with a cheap €99 Dirt Devil with manual empty, manual charge and have upgraded as and when we thought we would use different features when we saw a good deal. I would defo recommend this approach as not so much to lose out on if it turns out you just hate it, or it doesn't work for you. And, a cheap one with barely any features will do 99% of the job. IME the upgrades don't improve things massively in relation to the original functionality.
We are a bit messy/disorganised with multiple ADHD kids etc. Socks are normally a bit too big to bother it, though if caught at the wrong angle it might try to eat it and then get upset or just trundle around with it stuck for ages, but it makes a different noise when something is stuck, so you'll usually notice. Small lego pieces like the 1x1 blocks will just get eaten. If you have manual empty you might notice in time to rescue them, although self-emptying models will suck it into a bigger hoover bag which means they will be gone forever. Bigger lego pieces like 2x2 blocks will usually get stuck in the rollers and it will make a loud noise or error and you'll have to flip it over and get them out. This is also an issue with random bits of cardboard, bread sealing metal foldy clip things, pen lids, burnt chips or dropped bit of dry pasta, hairties with decorations and other small toys. Toys which are too big to fit underneath it (which is normally about 2cm) will either get pushed out of the way or treated as an obstacle and cleaned around, they aren't in danger at all. We used to have endless fun when DC were toddlers just filling the room with various balls and letting the hoover bump into them.
The main issue is charger or headphone cables - it gets horribly tangled in these as they often wrap around the little brushes, which damages the cable as well. Or things like if you have plastic bag storage and a bit of a bag is hanging out and touching the floor, or a bit of thread trailing from a pile of clothes etc, it can suck this up and disrupt the whole pile.
We tend to do a bit of a tidy around/sweep for stuff the hoover might eat before we put it on. The DC fairly quickly got trained in what this means as well.
It doesn't do as good of a job as a proper hoover, because the motor is much smaller and less powerful, so if you are expecting it to take over from your main hoover, I would forget that as a goal. However, it does an excellent job of removing 90% of the small bits of grit, dust and dirt which seem to constantly accumulate, and it definitely reduces the amount that we need to do a full/proper hoover. In fact most of the time I can get away with just spot cleaning with a handheld one, but I do like to get the "big" hoover out every so often to do more of a deep clean.
Unless you have one with a programmable schedule (and we don't use ours because of the need to do a "hoover sweep" first) you do need someone to be organised enough to remember to turn it on. DH is happy to run it during the evening while he does something like play games or watch TV with headphones. I hate this but tolerate it because I would forget to run it otherwise. I would prefer to put it on just before we go out or program it to run overnight when we are asleep, but I forget to do that, and DH is reluctant to do it overnight in case we forget to prep the floor for it, and because we can hear when it gets something stuck and sort it out. I dislike the fact that it runs for a long time and makes a noise the whole time, even though it's not as loud as a proper hoover.
We did upgrade last year to one with a mop function and while I admit this is slightly better than not mopping at all, it is pretty gross because it's just slugging dirty cold water over everything realistically. I would not describe this as a "mop" function more "wipe with a dirty cloth". It is just not practical for it to return to base to clean the pads as often as you would need to if you were actually cleaning a floor adequately. We do fill it with a dilute floor cleaning solution but it gets gunked up constantly and sometimes when it's running I'll walk past it and the pads absolutely reek like a honking cloth which hasn't been washed in months. And this is with changing them fairly regularly, we got a set of replacement ones so I swap them out and put them through a hot wash.
Mop function not functional enough to justify the faff, IMO.