Macro Algae is a type of algae that is used to remove nutrients, such as nitrates from the water. It is good to have but no mandatory, and it really depends on what type of tank you have.
There are some forms of macro algae that can be used in your main display tank as decoration and there are others that should only be used in a sump/fuge as they can spread easily and overttake a tank.