Quitting a job is like leaving a party. You probably didn't like everyone there. You probably avoided some people. That's where the Irish Goodbye shines. You get to leave without having to decide who to say goodbye to, and avoid long winded and shallow well wishes. As long as you aren't burning bridges, it actually benefits both sides in a lot of ways to just ghost on coworkers.
It also benefits you, more than you know.
I've been very lucky to never have a boss or team that I didn't feel that way about.
As for keeping a personal relationship, giving two weeks to maintain friendly relationships with a manager is just something weve all decide to do for seemingly no reason. Unless you work in a no skill job, you are not going to be replaced in 2 weeks. You are also not going to be able get an actual knowledge transfer done in two weeks unless your team had already done this before you quit, in which case the notice period doesn't matter anyway.
The two weeks notice period just let's companies get another two weeks of work from you, at a job you have explicitly decided you dont want to stay at
It's not just your manager, it's your coworkers, it's your team. You don't want to leave them hanging at a critical juncture with no time to find a replacement. It's not for no reason, it's because relationships matter, more than you know, and it pays a lot of dividends to invest in long-lasting relationships that carry on even beyond your job.
I get the concept of not burning bridges, but you gotta ask if the bridge is gonna take you somewhere you want to go
Edit: Additionally, every job I've worked at in my career has wanted me to start ASAP. I've even had one explicitly ask me if I could give my previous employer less notice so I could start earlier
People that resign may or may not be allowed to stay for the two weeks, depending on how much the company was relying on them (often the companies didn't really have much redundancy or documentation in place and needed to train someone new and/or do a few meetings with infodumps with these people)
But that's the only 'courtesy' I've ever seen.