Ok, maybe repeating bit here but....I foster for a small independent rescue, and several of my foster dogs, including a four month old pup and a huge GSD x have gone to homes with young children. They went to families with experience of the breed and children who were gentle and well trained around dogs.
There are litters of virtually every breed being born in rescue every day. There are litters of puppy farmed puppies being seized now most weeks at the ports by the SPCAs. All these need proper homes.
And back to the original question... unlimited puppy cuddles are the best, watching your puppy grow up and learn new stuff is amazing, a puppy can take over your life in the best possible way. :)
The downside is that a puppy can also destroy your house by chewing everything in sight, and it will seriously restrict you life for quite some time. It's like having a baby, and then a destructive toddler. You can't leave them for any length of time as they need regular meals and taken to the toilet, you either have to take them with you or find a reliable baby sitter. You will be going back to disturbed nights and sleep deprivation and will start to think walking round the garden in the dark at odd hours of the night is perfectly fine.
FWIW I think beagles are incredibly cute but are a very popular puppy farm dog so I really wouldn't consider it. Their scent drive would also make me nervous, but mainly because I like walking dogs off-lead and I don't know if you could ever reliably do this with a beagle.
As PPs have said, the first thing in getting a dog or puppy is to seriously consider what you want it to do - is an hour round the block the most you will manage or are you likely to go out on a full day's hillwalking or are you a runner?
If you think you can get a puppy and then leave it at home to go to work, just don't.