Has anyone tried to self host the supabase on one of the cloud providers (aws, gcp) if so what would you say/advice to someone who's going to go that route?

It depends what you specifically define as 'cloud provider'. Any provider which can support a Docker environment (e.g. a VPS with Docker installed) can run Supabase. DigitalOcean can do it, so I'm confident AWS could too