The risk picture has improved a lot since the days when public Wi-Fi was a free-for-all, mainly because HTTPS encryption now protects nearly all meaningful traffic, so a snooper on the cafe network can see which sites you visit but not your passwords or card numbers. That said, real attack vectors remain, and tourist-heavy locations are where they concentrate.
The main ones: evil twin hotspots, where someone broadcasts a network named almost identically to the venue's real one and routes your traffic through their laptop; malicious captive portals that phish for credentials or card details; and exploitation of devices with sharing services left on.
Your defenses are simple: verify the exact network name with staff, never enter payment details on a Wi-Fi login page, keep your device updated with file sharing off, turn off auto-join for open networks, and use a reputable VPN if you connect to public Wi-Fi regularly.