Hi Tim I totally I agree with you.

I feel like the posting here and the documents I have read is some
what contrasting? (about using index)

I really like to learn more about using index indepth, about the
plans(how to read and to force to use the plan that could result to
the fastest performance, and some tips and tricks)