Pittsburgh's PNC takes the trophy on this IMO, at least amomg MLB ballparks.
Chicago dropped the ball on this by orienting not just one, but both of its MLB ballparks, to face away from downtown.
Whoops.
At least Wrigley still has a decent skyline view of sorts of the residential towers along the lake in east Lakeview.
Not the best ballpark view in the majors, but certainly still good.

Source:
https://myrgroup.com/projects/wrigley-field/