Sydney’s public transport and Opal card regime will get an $820m overhaul that promises to fix one major bugbear for commuters.