I hope it is okay to hook into this discussion.
I experience the same issue. Hardcoded Fields won’t give me the option page values from sub-sites after the switch_to_blog(), but ui-created fields work great.
I tried to debug it. The created query is alright but it gives ACF no data back.
SELECT option_value
FROM sw_4_options
WHERE option_name = ‘options_standort_color_main’
LIMIT 1