To put it in perspective, a single bitcoin transaction can power the average american's household electricity needs for... an entire month.
So roughly somewhere between $70-$150.
The number of transactions that are completed on the base layer is not the relevant metric. As the technology matures and as Bitcoin is more fully monetized, transactions will happen on higher layers. The "high" energy cost is necessary to secure the decentralized system.