Absolutely. There are many games that either don't have demos or the demos are too short to actually know if you like the game. For example, I played Octopath Traveler Demo and I loved it. But it's not until you play for like 8-10 hours that you realise how utterly repetitive ans boring the story/level design cycle is.
If I had had the option to rent the game for like 5 bucks I would have saved 45 dolars.
So yeah, I would love to have the option