kevinmckeown8 - I appreciate the suggestions and I also use a separate service account for creating our enterprise Flows that users can use or that run automatically on item changes. I could easily create the option for them as well like you described, but then our context isn't relevant to this built-in feature Microsoft has provided - as many of the comments are not related to this blog and should be posted in the general Flow community. Not to take away from the value of workarounds to accomplish a need, but I was simply stating that the published content describing this feature are a bit misleading and the feature might be quite annoying given the results of "reminding you" of every single item in the list that fits within the query every day that the user defined once.
As a long-time veteran of SharePoint and Office 365 evolution it can be extremely frustrating how many things are released that either are broken, don't do what it appears it should do or cause issues depending on how you interact with it. It feels that every 2-3 weeks I'm putting in a support ticket with MS over a bug I've found only to be dismissed as "by design" and pointed over to the lost sea of User Voice to try and get it enough votes for it to be noticed and fixed.
I've been in this career for some time now and absolutely love so many aspects of it, which is why I'm in it, but Microsoft really needs to work better on the QA side of their 365 products before releasing them into the wild. It's the worst feeling to show users how great a feature or product is only to find bugs that require you to retract your recommendation for it until it's fixed in some unknown timeframe.