Local players and players born and bred within the club will care and they will be the ones that stay throughout their career and not jump when in their prime - Gerrard , Terry , Lampard , Carra , Neville , Scholes , Rooney
I just need to check this. Were you drinking when you added Rooney to this list? Why would you add Rooney to a list of players that stayed loyal to a club and didn't look to jump. Rooney moved through the Everton junior system and then jumped to Utd, anyone but Utd blimey. Every few years at Utd he threatens to leave until his contract is bumped up. Clear as you like, more money or I go. Rooney will retire and no fans will love him in the way they love the other players on your list. Incidentally, throw Alan Shearer into that mix. Ask him if he would swap titles with Utd for the years and adoration from his home support? He wouldn't blink in answering no. He is still worshipped for that loyalty, Rooney will not have that.
As a pro you make that choice, if you are lucky. It's a short career and it is up to each individual. 10-20-30 years after you are finished it must be pretty nice though, going back to your old club and having people happy to see you still. That has to be worth something more than just rattling around in your mansion counting your money.