Hm, the main headache I have with .env files is simply that I lose them (switching between machines etc...), or the trouble of sharing secrets with team mates, etc... The headache of keeping them up to date and synced across environments & machines.

Not affiliated but those troubles are now finally solved with Infisical for me. It's open source so I happily give them a plug.