The Build Mode features in 4 are pretty good if you’re into virtual dollhouse building, and there’s a ton of custom content for it (as long as you’re on PC).
Live Mode is not very good, but it’s functional enough to play dolls in the houses you built if you’re willing to do all the story writing to make up for sims not having very interesting personalities/desires/autonomy.
Even if you buy a DVD, the only thing you are “buying” is the physical media and a license to operate the softwate. You don’t own the software stored on the media, you must use it in accordance with the license agreement or potentially face legal action. The main thing about digital storefronts is that it’s easier to revoke the license.