We have berber on our stairs, bamboo in most rooms, ceramic tile in an entry way, hickory in the kitchen/dining room. We live in Tahoe so dirt and water are always getting tracked in. Our family is 2 adults, a 2 yr old boy, and a 13 yr old dog.
The berber is lovely to step on, very soft. It would be impossible to get stains out of, but it was cheaper than hardwood on stairs and much less slippery.
Bamboo looks great and was the cheapest option for hardwood, but it gets scratched very easily--rolling across it in a desk chair left marks. But it is very easy to clean which is good because it shows every speck, crumb, or hair and has to be cleaned often. But it reflects light nicely, brightens the rooms. I like the bamboo even with it getting marked up (decided that it was like linen, you've got to go with the wrinkles).
The hickory is real hardwood (not engineered) and was quite expensive. It looks marvelous. If we could have afforded it, we might have put it in the whole house. The installation is tricky and if not done right it gaps and moves. Also we had some "water" damage from the old dog and that area doesn't look great. If we didn't have an old dog and had an unlimited budget, we would have put the hickory in every room except bathrooms and entryways.
Tile is the most durable and probably would be a good choice in any room with the possibility of water, food, or whatever spilling on it.