I think this will vary based on the lineage, honestly. Some working dogs are way, way too intense to not work every single day (I’m thinking Czech GSD for example). I think your best bet would be to straight-up ask the breeders, ask people who have previously bought from the breeders, and look into training your dog to settle in the house.
Don’t automatically discount show-line dogs from sports either! Many show-line breeders strive for versatile (but conformationally correct) dogs. Show-line dogs are more likely to have that “off-switch”, but again, it’s probably something you would need to discuss with the breeders and then work on training.
-C