It looks to me like colonizing a significant portion of the Americas is worthwhile if you do one of two things:
- Also secure yourself a substantial Old World land empire, so that you are stronger than any one of your colonial subjects and thus have a reasonable chance of putting down a colonial revolt.
- Move your capital to the Americas very early in the process, so that you are no longer subject to the colonial nations mechanic.