so I was just wondering if the automated weather report is mandatory (if it reports weather below VFR) to comply with.
Yes it is. You must comply with the minima for the class of airspace you're in. In some places the class of airspace changes (becomes uncontrolled) when the controller goes home in the evening so the limits could change, but there will still be limits, and if the METAR says you're below those, you cannot depart.
But when the controll tower is not in operation, then you probably not get a clearance this easily
If the airspace becomes uncontrolled, then SVFR is not possible. If another unit takes responsibility for that bit of airspace, then you have to request a clearance from that unit.
Is this forum french orientated?
No, just me
This is mostly Brits and a few continentals, with the odd Merkin and Antipodean sidekicks to complete the mix.
Do you now some aviation forums US orientated?
Nope, sorry, but I'm sure others will help you with that.