I was browsing hotel sites this morning and it looks like things are pretty well booked for the next two weekends downtown. All four games at Comerica Park will be on the weekend. Windsor did have availability. They do run shuttles from Windsor to the stadium for the games, but I have never used it. You can also take a cab, but you have to pay the $5 tunnel fee both ways.
I was at the game Saturday night and the stadium area, greektown and everywhere else was packed. The lot that normally charges me $5 was up to $20, so a cab may not be that much more expensive.
If you are not Downtown or in Windsor, I would recommend the rental car.