This depends on quite a range of factors (e.g. what country you're in, what your personal risk profile is), so depending on the answers there, VPNs are more or less useful (from a security perspective).
I'd expect that a lot of VPN use these days is geo-shifting to get access to region locked content, and they're not a bad idea for that.