I'm biased, but here goes -
Don't get a working dog unless you can keep it active, ideally with you all day. If you can do that, and train it properly, then they are the very best of dogs.
Personally I prefer hounds. They are quite happy to lie around all day so long as they get a bit of excitement at some point - needn't be a long run so long as it's hard. Favourite running dog? Wolfhound or Great Dane, but make sure there's no hip problems. Produce prodigious amounts of poop, so best for open country unless you like scooping.
If you like an enthusiastic best friend ever dog, there's nothing like a Staffie.
Avoid dogs that have been bred for "beauty", brains seem to suffer, with the exception of the big poodles, which are a good dog.
Basically dogs break down into 4 classes, basket dog, ankle dog, knee dog, proper dog