Archival mode (no pruning, txindex=1) is the precondition for any service that needs to look up arbitrary historical transactions: Electrum Personal Server, Electrs, Fulcrum, Mempool.space, full BTCPay Server with payment history, and any block explorer backend.
Without txindex, Bitcoin Core can only look up unspent transactions through the UTXO set. With txindex, you have full historical access at the cost of ~30GB extra index storage and some extra IO during the initial sync.