If I use Redis software on AWS, am I getting the most value, or does AWS? Exactly by offering ready to go implementations of known open source projects, are they increasing or decreasing my AWS lock in? Does it even matter? If they didn't offer these, which are saving me effort (thus money) today, wouldn't I just be running these myself on an EC2 or ECS setup?
Wouldn't that apply to all cloud providers, not just AWS? All of them are heavily based on open source software, from Linux, KVM/Xen, and K8s to MySQL/Postgres, Kafka, Cassandra, etc.?
I don't think OP is right at all. Just because a company offers managed instances of any random FLOSS service that does not mean they are profiting out of that service.
From the customer standpoint, the choice is between running self hosted instances on bare VMs or use managed instances, and if managed instances are not available then they don't have a lot of alternatives. Managed instances are cheaper to run and operate, and are more reliable, thus it's more advantageous to use those services. For the cloud provider, they are getting paid either way.
It's not like function-as-a-service offerings, where cloud providers charge users a premium for computational resources that run on spare cycles and allow far higher utilization rates, thus getting paid in two or three different ways.