I often book a standard room. My usual go-to is to request the Adventure Tower or Fantasy. Now, with the new DTD entry point, I think this may make Frontier a little better, location-wise, than before. However, one whole side of it still looks out on a parking lot and uninspired city views. In Fantasy, one side looks out on part of a parking lot, true, but also has park views and some great fireworks views. The other side has mostly pool/resort view rooms. A lot of them are considered standard view.
I have no experience with the new DVC rooms but the tower looks really nice.
If a sale comes along, that would be a good time to consider upgrading. My favorite is a room on one of the upper floors of Adventure, DTD view. Since I've been many times and I am not usually with kids these days I care more about where I am in the resort than what view I have. I prefer being close to DTD.