Forcing join order has these risks:
Misuse can lead to extremely expensive queries. Always test the query thoroughly with statistics io, and with and without forceplan.
It requires maintenance. You must regularly check queries and stored procedures that include forceplan. Also, future versions of Adaptive Server may eliminate the problems that lead you to incorporate index forcing, so you should check all queries using forced query plans each time a new version is installed.
