Weekly is the sweet spot for most sites, in my experience. Daily checks are useful only right after a big change — a migration, a core update, or a new page going live — because day-to-day movement is mostly noise and it is easy to overreact to it. What I do is track weekly for the main money pages and keywords, then do a proper monthly review where I look at trends, search console clicks and impressions, and which pages actually gained or lost traffic. That monthly view is where real decisions get made: if a page has slipped for 3-4 weeks in a row, that is a signal worth acting on, whereas a one-day dip usually is not. Also worth separating rankings from visibility — a keyword can drop a spot while clicks stay flat if the SERP changed, so always check impressions and CTR alongside the rank.
I agree with RashidNikzad that weekly is the sweet spot for most sites, and I would add that it depends on what you do with the numbers. Checking every day is tempting, but day-to-day movement is mostly noise from personalisation, location and normal search volatility. I have seen people rewrite a page because it dropped two places on a Tuesday, only for it to be back by Friday without any change. What works for me with a small site is a weekly check of a short list of the keywords that actually matter, meaning the ones tied to pages that bring in enquiries or sales, not every variation I could think of. I note the movement in a simple sheet and only act when something has moved in the same direction for three or four weeks, or when a page has clearly lost traffic in Search Console. Daily checks are worth it for a short window after a specific change, such as a migration, a big content update or a new page going live, just to catch anything broken early. Outside of that, a monthly review is where the real decisions happen: looking at trends in clicks and impressions alongside rankings, and seeing which pages gained or lost over the quarter. So for most small businesses, weekly tracking with a monthly review, and daily only briefly after a change, keeps the habit useful instead of turning it into a daily worry.
For a local service business I'd add one thing: the map pack ranking depends on where the searcher is standing, so a single rank number checked from one spot can look fine while you're invisible two towns over. A monthly check from several points across the service area tells you more than a daily check from one, and the weekly number I'd actually watch is calls by town, since that's what pays.