Advancing Sustainable Transportation and Aviation: a Multi-Scale Analysis of Zero-Emission Vehicles, Green Hydrogen Production, and E-Fuel Integration