There are some sites on which I appreciate them, but exclusively those are sites where I have accounts and would otherwise revive them over email or something. Anything that asks to show notifications on first load gets "never show".

...which are just the spam mail of 2008, which were just the extra-volume used car ads of 1999, which were just the pushy salesman of the 19-aughts.

Everything new is old and notification prompts on first visit are still a terrible idea.