I live in Paris with an arguably good public transport system in place and Lime scooters were quite popular this summer. This is only anecdotally ofc, but you see a lot of people using them. There are not as many Bird scooters yet though.
Where I see the niche is medium distances were the metro is not a fast solution but if scooters are ubiquitously available for these situations, I see value in them.
And yeah, Tourists seem to love them.