Text this: Decoding the Mystery: How Can LLMs Turn Text Into Cypher in Complex Knowledge Graphs?