On the topic of hamsters - they're nocturnal. My Syrian regularly doesn't get up until 8/9pm at night, which is often after DC's bedtime (but delightful for me as a working adult). You can't wake them up - they tend to be grumpy and potentially bitey if you do that.
Do be aware that they have needs above and beyond what Pets at Home and other such pet shops will tell you about. They must have a cage that is at least 80x50cm unbroken floorspaces (shelves are bonuses, not to be included in that figure) and ideally bigger. I recommend the Zooplus.co.uk Alaska / Barney / Alexander. The largest hamster cage sold by PAH is half the minimum, for context.
Syrians must have a wheel that is at least 28cm in diameter. Any less and they will have to bend their back or neck to run, and that causes painful spinal problems.
Syrians are the easiest to handle, but can be quick, especially when they're young. Mine will let you know when she's bored and feels she needs new / different toys. She's very friendly (thanks to many months of careful, non-grabby handling) and always wants to come out - she usually needs an hour per evening.
Dwarves aren't great pets for children - they're faster, harder to handle, pairs often fight (even if you set up their cage especially to reduce territorial behaviour) and have to be separated. Plus, the dwarf hybrids / Russian dwarves are very prone to diabetes and need a special diet + monitoring. You're better off with a Syrian hamster.
If you do decide you want a hamster, go in with your eyes open, do your research, and rescue one, either directly (via classified ads) or via a rescue group. They can be wonderful pets for older children and adults, but the general perception that they are "children's pets" often leads to a disastrous underestimation of their welfare needs.