At least in the case of Portugal, the visa usually used by retired people is the D7 visa (not the golden visa), which requires a source of income not related to your work (eg: pensions). So you still have hope!