When we already talk about Fraunhofer, they with a few other institutes, have been sketching out various pathways over the years for Germany for transitioning to a renewable energy system multiple times, see https://langfristszenarien.de/enertile-explorer-wAssets/docs...
While Germany has some hydro, it's just a tiny amount