Electrs (the romanrenz/blockstream variant) is the most common self-host choice. It indexes the full Bitcoin chain into RocksDB and exposes Electrum protocol. Storage cost: ~100GB on top of the Bitcoin chain.
Compared to Fulcrum, Electrs is more memory-efficient but slower at the initial indexing step. Compared to ElectrumX (Python), it is dramatically faster and more reliable.