Goff's agent will obviously be looking for the biggest and best deal, but I feel like Goff has a career redemption arc that can only be completed in Detroit.
He still has the chance to be seen as Detroit's franchise QB, the guy who finally got them a playoff win, even multiple wins over multiple seasons. But if Detroit moves on from him after next season, his age 30 season, the press will label him as a "journeyman" QB.
His best long-term option is to stay with Detroit, even if his extension is not at the top of the market, even with Hooker waiting in the wings.