As much as I think Holmgren would love to be the hometown hero, I doubt he'll leave what he's building out in Cleveland. Plus it's pretty much certain Gruden (Ohio guy) is gonna be HC under Holmgren at GM.
The only reason I would want Holmgren would be to instill the West Coast Offense philosophy into a young coach and continue the 49er Legacy. Plus Holmgren is getting pretty old.