Can Visa or Mastercard or PayPal offer the same service at the same price for micro transactions like this?
Yeah, something similar already exists in Taipei:
https://www.taipeibiketours.com/single-post/2017/06/06/How-to-Use-Taiwans-Youbikes-in-8-StepsThere's a deposit if you pay with credit card, but they're actually a lot cheaper. The other alternative (or rather the main option), EasyCards, can be used to pay for just about any public transportation and is accepted at major convenience stores if I remember correctly.
So yeah, the Lightning Network isn't really breaking any new ground here, but I'd say it's still a very interesting proof of concept. This won't excite you if you've never doubted the Lightning Network, but it should be pretty fun for skeptics.