As I understand that general recommendation is to stop using LF index and use HG index in IQ version 16 onwards. If so how come Index Advisor still advises to create LF index?

The problem with LF index for us that we hit the bug # 2200808 with NOT IN clause.