we adopted a rescue 1.5 years ago. He wasn't a puppy (and puppies are a whole other issue)
He doesn't scratch the furniture
He isn't a barker
He doesn't jump up whenever anyone leaves, but he is first to greet people at the door, (somewhat enthusiastically) and it has taken loads of training to stop him swamping visitors.
He never wakes us up, excpet once when he was ill.
We do now have to hoover more often (or live with the dog hair, and boy there is plenty of it, but then he is a fluffy spaniel) and for that reason, he is not allowed on the sofas, or in our bedroom.
On the other hand, I cleaned the kitchen this morning, the wall by the back door was truly disgusting (I hadn't realised just how bad it had become) as he comes in and then shakes, so mud and water etc spray all over the wall. Same with the wall round his food bowl, and the door from kitchen to dining room, and the back door, and the front door, and..... you get the picture.
The walking is the biggest tie, two days this week I have been absolutely soaked to the skin as it was raining, dog needs a walk, and the forecast was for rain all day.
I would say, borrow a dog. Several different dogs if you can. We had 3 different dogs who came on holiday to our house, over a period of about 7 years. For most of that time I loved having them, but was happy to see them go home. It was only in the last year that I said that I was happy to take on the walking (not waiting for my teenagers to do it!)
I would also say, that nice dogs are well trained dogs, and the better you train, the nicer the dog.