Can you help me pick a species of tree for the yard?

At my parent’s house there’s this spot on the corner of their property that needs a tree. The house butts up against a golf course fairway, and the spot where this tree will go has been problematic in the past. There was originally a large oak there that died, and a cherry tree that died as well. I suspect it’s because it’s a low-spot and is getting too much water as the other oaks and cherry trees are doing fine.

My parents would like to plant something there that won’t get too huge and block the view of the golf-course (and tick off the neighbors), but at the same time “anchor” that corner of their yard. It gets full sun almost all day, lots of water, and is in Virginia, so it would have to deal with the summers/winters here. Any advice on what species of tree might look good and do well given the somewhat challenging limitations would be greatly appreciated.