When to use query hints?

When should we consider using query hints in database management systems, and what are the potential benefits and drawbacks of doing so? Could you elaborate on the scenarios where query hints might be necessary, and how they can potentially optimize query performance or execution plans? Additionally, are there any risks or limitations associated with relying heavily on query hints in production environments?