If you have a destructive dog (no way to know in advance) you either have to crate it or risk destroying a lot of your stuff. Crating a dog is pretty sad and the dog won't like it. So you're basically trapped at home.
Most dogs will become accustomed to staying in a crate with a bit of training. But certainly don't get a high-energy dog with a strong working drive if you're not going to be able to give it a lot of activity.
The way to know in advance whether a dog will be destructive (after the puppy teething stage) is to buy a purebred. I know that everyone recommends adopting from a shelter, and that's a great option for many dog owners. But if you need more predictability then you can select a specific breed based on known temperament and typical behavior, then buy a puppy from a reputable breeder with good health records.