Unfortunately, you can’t. A residence card gives you a visa-free access to EU member countries and even the right to stay there for a short time, but does not give you any right to settle there.
You can only make your dream come true if you get a passport after several years of being a resident. In Malta, an investor can obtain the European citizenship in a year’s time after getting Maltese residence, provided they have made additional investments in the economy of Malta.
EU citizens indeed have the right to live in any EU state. Given that German, French or Spanish citizenship is rather difficult to obtain, and the process might take about 10-12 years, investors first relocate to the jurisdictions offering citizenship in 1-5 years’ time, and as soon as they have obtained it, they settle in the state they choose.