Actually it make 100% sense to have no real alcohol on a star ship.
I mean you dont want the crew to go off duty to a party get pissed then a borg ships appears?
Anyway I though synthahol did have intoxicating effects but they went rather quickly. So rather than knocking back beers and then waiting hours before you can drive. You can still knock those beers back then wait 30mins then drive!