Looking to get a new sight & would like to harness the vast knowledge available on this forum before I decide.

Simple theory:

Which are good?
Which are mediocre/ok?
Which to avoid at all cost?