Yes, the VPN will see your data (SSL will still protect things like login info, etc). Basically, you put your faith in the VPN provider that they won't turn your ass over to the authorities if they get a copyright letter.
But no, it's not the same as openDNS at all. OpenDNS just gives you...