The Warriors are pursuing him to become their head coach. The Pistons are pursuing him to become their head coach AND director of all basketball operations.
The Warriors obviously have the better roster, but having total control to build his own team in Detroit could have its appeal.