I'm really mixed on this. If they truly had multiple offers involving 1st round picks, I suspect this deal will not end up being the best offer.
Taking on Goff is a real headache, in my opinion. First, I am of the opinion Goff is just terrible. He comes across as aloof, not terribly bright for a QB, and seemingly needed McVay to really guide him to his average results. I just don't see any scenario where there is a career revival here, which I don't think many are expecting anyways. Second, and more important though, is that taking him on blows up their cap this year. I get that they are looking at a multi year rebuild, but as far as cap, they are in a position to trim a lot of dead weight over the next 2 years. With the cap being depressed this year, there will be some players stuck taking lesser contracts I would expect. Detroit could have been in a position to potentially take advantage of that. You don't rebuild via free agency, but you can help it along through that avenue. That has been diminished with the Goff contract on the books for this year and to a lesser extent, next as well.
I'm happy for Satfford, it sounds like he wanted LA, and he got LA. I'll be rooting for him there. I just have this feeling that this wasn't the best deal Detroit could have made. I guess that feeling just comes with being a Lions fan.