BUG: Index formed with list of tuples return wrong output in eq ops

[charlesdong1991]

xref #34137

Currently

>>> pd.Index([('a', 'b'), ('b', 'c'), ('c', 'a')]) == ('c', 'a')
>>> array([False, False, False])

The issue is such case is treated as a MultiIndex other than plain Index.

Expected:

>>> pd.Index([('a', 'b'), ('b', 'c'), ('c', 'a')]) == ('c', 'a')
>>> array([False, False, True])

[asishm]

@charlesdong1991 It seems this is currently failing on master with ValueError: ('Lengths must match to compare', (3,), (2,))