I'd say Atlético de Madrid, it ticks all boxes until your current times: similar size of stadium and fans reputed for passion/high expectations, perennial underachievers, mental ownership, always assemble good squads on paper that flatter to deceive... they probably lack the regional pride bit.
Yeah, now you say it...