I haven't upgraded, and the notifications are fairly rare and unintrusive.
I get it at least once a day. Sometimes as "Update to Tahoe" and sometimes as "Install pending updates tonight".