Park dimensions + team makeup is a combination that can contribute heavily to home team advantage. The short porches in Yankee Stadium (especially in right) have traditionally granted an advantage to the Yankees' often left handed sluggers. The more the field dimensions vary from the norm, the more the home team has an advantage to tailor their team makeup to exploit them. Parks with high walls, short porches, heavy prevailing winds, deep outfield fences, or absurd dimensions ( Think Willie Mays fielding center at the Polo Grounds) all present opportunities for exploitation.
While the Astros had more wins on the road than at home during the regular season from 2017-2019, their 2017 postseason home/away batting splits were wildly inconsistent. Boston had the best home record in MLB by six games during the 2018 season in which they were found to be relaying signals to batters. I'd suggest that home field presents a greater opportunity for outright cheating as well.
Do you think it has to do with roster building? Like the Rockies don't spend money on pitching because pitching has less value at Coors, so they load up on offensive talent instead?
While other teams play a single (or handful of) series a year at Coors Field, the Rockies have to adjust to breaking pitches being more effective while playing away half the time which would be a bigger disadvantage than the ball not flying as far at away ballparks.
With the caveat that this is for baseball and not football, home field advantage has shrunk tremendously over the years. Just look at the curve of "field kindness" over the history of the MLB, it is insane how much of a difference the field you were visiting used to make!
https://neosmart.net/blog/2016/homefield-advantage/
(my favorite bit is the curve ball when it comes to fields that confer a statistical advantage to the visiting team!)