Hi Melanie,
We go through Vaccums ever 1-1.5 yrs so we get one less than $100 every time (don't know why we are so rough on them, I don't vaccum Every day even).
I have a Bissell 3-in-1 Broom Vac and that is Fantastic for getting up "big Stuff" that you can see, it's small/lightweight and you can use it like a hand vac Or broom vac (great for stairs)plus it has a crevice tool and it was about $20 dollars-like I said it's the best thing I've found for spot pick-ups and that way you can just get out the big vaccum when you want to clean bigger areas. Only downside is that it's corded, but the cord is long enough you can do a small room easy(I keep an extension cord in the pantry to use it in the Family Room as it's 650 sq ft ;-). I Reccommend this little big guy as a perfect every day picker-upper :-).
As for a "big" vaccum purchase, my oldest Neice has a Dyson and LOVES it (she is a neat freak and vaccums at least every other day-maybe every day :-). It's the small version(don't remember what they are called) she is not a big girl- 5"3'and about 100 lbs so the smaller one is perfect size wize.
The only thing we hate is the chambers you empty-we prefer bags, they put much less dust in the air when emptied, plus they are cheaper than filters, and most get up as many allergens as the ones with the Heppa filters on them-our cheap Hoover bags get up 98% of all dust/allergens. My Neice empties hers in the kitchen, But she doesn't have kids, so that part is a toss up.
I used a friend's rainbow a few times and they are Great, but as you said kind of a pain to use.
My Last bit of advice is check Consumer Reports-they have an online "subscription" and you don't have to wait till the magazine gets to you. My In-Laws get us C.R. every Christmas and it has been a Great Tool in helping to buy appliances. Also, our Vaccum broke and was under warranty, we took it to the repair place in our area and the owner told me Panasonic was a Great Vaccum as far as Suction and not needing maintenance (he is also a Dyson Certified service provider).
Hope this helps,
C.