I just call our OVH services "the could" to placate people.
Sure cherrypicking postgres since it has more experience as "on-prem". Try and replicate s3 type of service for me or something like sns - even without fancy stuff.
You can still use S3 even without being on AWS, though for more reasonable (< 1TB) amounts of data, old school local storage served by Nginx does the trick.
For SNS, what does it offer that RabbitMQ doesn't? I've always found RMQ to be rock-solid and wouldn't use SNS anyway.
The only risk I can see is the lack of managed services, but Postgres isn't that hard to manage yourself, and other value-add AWS services can still be used (the cost savings of your baseline load being on bare-metal would most likely still offset the bandwidth costs of moving data between AWS managed services and your bare-metal host).