[1] https://www.doll.eu/de/produkte/schwertransport/nachlaeufer-...
[2] https://www.wiwo.de/technologie/wirtschaft-von-oben/wirtscha...
So near-site in practice means, near-harbor.
Possibly you can have an agile vessel doing the last stretch so that you can change that to ~near-sea.
The base is segments (shaped like calamari rings), which are big but usually can be transported by road, but the big ones probably can't pass under bridges.
Afaik, they are built in dedicated factories but usually on the same continent (at least!) as where they are going to get installed.
... but why calamari rings specifically?
Here are some images to give you an idea of the size of large wind turbines https://growsverige.se/2023/02/11/storleken-svindlar-pa-nya-...