I can't remember the name of the one near me (had a slick photo of black and green pi cases on their dc floor), but a little googling found this one: http://raspberrycolocation.com/
It doesn't have to be powerful because I'm the only one using it. Since it costs me EUR0/month, why not? Isn't that what hobbyist tinkering is about?
I also don't think the stack would matter all that much at this point - IO blocking would be happening at the application level, not the architectural. Node, Go, Ruby, Python, PHP ... it really wouldn't matter. SQL versus NoSQL is also a non-issue in this case.
I also wouldn't take something very underpowered instead of the cloud just because I hadn't configured my cloud host to keep things within reason (ie no autoscaling at all, which is what you'd expect for hobby-level prototyping.
tldr; don't eschew better options for the Pi unless you don't understand how your cloud host works.