I know this is an old question, but I came across this page that has pretty clear examples of where each type of index, inverted and forward, are typically used.

https://www.pingcap.com/article/inverted-index-vs-other-indexes-key-differences/