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

xref #34137

Currently

```python
>>> 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:
```python
>>> pd.Index([('a', 'b'), ('b', 'c'), ('c', 'a')]) == ('c', 'a')
>>> array([False, False, True])
```
