Give Weatherbit.io a try:
You just need to install the integration manual from GitHub - briis/weatherbit: The weatherbit integration adds support for the weatherbit.io web service as a source for meteorological data for your location. or you use HACS.
Then you need to register at weatherbit.io for a free plan to get a API-Key.
Compare Cologne now - upper one the the standard met.no, the lower one is very close:
Actual measured:
