How many % do financial advisors get for managing your investment portfolio? Is it something to consider right now? ?

There are many types of financial services representatives. You have stock brokers (or formally called trading representatives), you have financial adviser representatives (which can market insurance, unit trusts, alternative investments), you have robo advisory (which essentially invests in ETFs most of the time, though there are some doing a hybrid human-robo model).
My suggestion is to shop around. Talk to a few people. Don't feel pressured to buy anything.

There is a difference between a tied representative from an insurance company, a tied employee from a bank, and a representative from a financial advisory firm. If you are looking purely for investments, you can probably skip the rep from insurance company, and the employee from the bank. Unless you just want to get some insights.
I don't know if you have covered your protection needs, or how savvy you are on holistic financial education. Hence, the best is really to talk to a few people. Don't feel like you owe them anything if you think their philosophy and style differs from your own.

In everything, there are always pros and cons. Be it a human financial advisor, a robo advisor, or diy investment. Understand the pros and cons and make a choice thereafter.

Most FA firms in Singapore are pretty okay. It's really the individual representative you want to take note of, and not necessarily the firm.

The title refers to a story about a visitor to New York who admired the yachts of the bankers and brokers. Naively, he asked where all the customers' yachts were? Of course, none of the customers could afford yachts, even though they dutifully followed the advice of their bankers and brokers.
Just subsitute the bankers and brokers with insurance agents.