I think for many people all around the country that 2017 Astros WS championship is tainted forever, and deserves an asterisk placed next to it (like the White Sox's cheating in 1919). For years afterward the Astros team was booed at most other ballparks. It has probably died down now for the most part (although maybe Altuve still gets booed occasionally, I don't know).
I was a huge fan, and the cheating really upset me . I had even met a number of Astros - two WS game winning pitchers from that year (Joe Musgrove and Chris Devenski), as well as numerous Astros from previous generations (Nolan Ryan, Mike Scott and many others back when I lived in Texas).
Both AJ Hinch and Cora served 1 year suspensions from MLB for overseeing the cheating. I think of both of them as cheaters as well. Hinch is obviously with Detroit now, and his team has the best overall record in baseball.
I don't know - it seems like many people view this as you do - it was bad when the Astros cheated (and many no longer hold it against the current team), but it's ok if the cheating players end up on the team I root for, and I don't care that they cheated.
I have problems with cheating in most sports - Pete Rose betting on games he coached in, Tom Brady & Bill Belichick's Spygate and Inflategate, Lance Armstrong doping, the PED era in baseball, etc. Maybe it's a "me" problem as much as anything.