This all can be scripted, and that makes it very powerful.
Another use case is Streisand, the VPN service that you can install on your laptop. You need an AWS account, keys etc, and then you can start up one small server as vpn for one or two hours, or for twenty minutes, each time with a different IP, from data centers all over the world. Need a server in Asia? In the EU or the US? It can set this up within the minute, if you have it configured properly.
So there are use cases for these services with price per minute. The problem with Scaleway is that they don't have the really expensive servers, and they don't have the scripting if I'm correct. I do have a server running there, cheap and not in the US, and it does its job properly.
For what you're discussing, then a VPS/shared/dedicated VM host is more than appropriate. But generally, when companies are going bare metal, they are not doing so for hours at a time.
So the question still remains, what is the use case for an hourly billed bare metal server?
The clients of ours that leverage the by-the-hour model generally use the same devops tools (Terraform, Docker Machine, Ansible, etc) against our API to provision and orchestrate bare metal that they would against AWS or DO to do the same with VM's.
The use case drivers for those who choose bare metal often seem to be price/performance ratios, network, bring your own hypervisor or not use one, etc.
But why was that? I'd say it was a problem with the supply rather than with the demand - bare metal providers didn't offer programmable, on-demand machines, and so the type of customers self-selected against those who were looking for those features.
Type 0: $0.05/hour ≈ $36.50/mo; Type 1: $0.40/hour ≈ $292/mo; Type 2: $1.00/hour ≈ $730/mo; Type 3: $1.70/hour ≈ $1277.5/mo