if it’s possible to set up a Serverless VPC Access so that cloud functions can talk to memorystore or other resources?

It looks like Terraform doesn't support it yet: https://github.com/terraform-providers/terraform-provider-google/issues/3401