As a veterinarian I have been reading thru this thread with interest.
There are different dogs that best fit in different environments and it sounds like a lot of the comments are from good dog owners.
While I know it cannot work in every situation, I do like hearing people giving shelter dogs/cats a home. Lately those seem to be one of the fashionable new breeds. . . When asked "What kind of dog it that?" more often than not I hear "Its a rescue."
As far as the OP goes, a French Bulldog would be a good companion dog. They are entertaining and friendly. You have to be cautious on over exertion, they can overheat and anatomically their breathing is not as efficient/easy as it is for a non-smushed face dog. Bulldogs of any type tend to be solid -- a running start from across the room can take you out at the knees!
I have nothing against Pits, I see a large number of them and while some are easy keepers a lot of them have skin issues. Combine the perceived viciousness with the ones that actually have a mean bone in their body and they can be a handful. There is a local group that works with them and better than half tend to have some sort of behavior or medical condition.
Most dog behavior problems I see arise from lack of attention from their owners. In these modern times of after school activities, electronic devices, etc. the pets at home can get less attention than they need. Dogs take a lot of work and effort, more than some people realize. As a previous poster said, cats can be good companions but less maintenance. . . but then there is the litter box.
Some of the best family dogs I see are Beagles (if you can get past the bark), Goldens, and Labs. A bit of space/yard helps with the larger breeds. Smaller dogs? There are nice ones out there but a lot of little guys -- Chihuahuas, Dachshunds, Terriers, etc. can have big attitudes and be a little nippy around people they do not know.
Best of luck with your new pup to the OP -- hope he/she adds an abundance of joy to your day.