Maybe not for you, but it's attractive to many people. It is, in fact, the most popular residence-by-investment program in Europe for the last few years.
From a tax perspective indeed you have way better options, e.g., you can have legal residence in Estonia yet retain UAE tax residency paying 0% tax while enjoying free movement in Schengen.
Tax and residency solutions that yield lower profits for advisors and intermediaries often receive less promotion and remain on the sidelines.
But tax is not the only determining factor. For many of us, the environment does make a difference, whether it would be in︀ the bedouin oasis desert camps of UAE, the romantic islands of Greece or Mother Russia's︁ human hives.