When time is of the essence, hints are often the only solution. The normal session level commands supported by Postgres are frequently inadequate because all that is needed is to fix a single SQL. Praises and kudos to the authors of this long awaited extension.
No cons. If the hints are not needed, don't use them.