It really prevents him from getting into too much trouble while we're away, but eventually when he's less "puppy" (he's currently 9 months), we'll slowly start letting him roam the house/yard for short periods while we're gone, working our way up to a full work day.
Fear not though, when we're home he's with us, and he always gets about 1-2 hours of exercise as well as a trip to our local dog park daily.
When he was a pup, we crated him. Never liked coming home to find destroyed property. We started by kenneling him in a bedroom, then letting him have the bedroom to himself, then more rooms with gates/doors blocking access. The more we trusted him, the more freedom he got. If there were setbacks, we'd restrict his access a bit more. Only took a couple of months.
Now with small dogs I have noticed similar, I get five minutes of fame. Visitors get a few more minutes than I, afterward its like ho-hum.
Don't assume dogs limited in their domain, even those confined to runs, have a miserable time. It all comes down to how they are handled and spoken too. Mean people tend to beget mean dogs.