Do we really need index hints? (forceLiterals vs forcePlaceholders)

Index hint is a new feature announced in D365FO PU23. When do we need it and what is the performance overhead of others alternatives.