In his own way, the siren sums up Sam and Dean’s relationship quite well. It’s like what the cosplaying couple from The Real Ghostbusters said: “To be Sam and Dean, to wake up every morning and save the world. To have a brother who would die for you. Well, who wouldn’t want that?”
There’s something incredibly powerful about having someone who loves you so much they’re willing to die for you, over and over again. Who knows your entire history, all your faults - every single thing about you - and is still so completely devoted that they’d sacrifice anything for you. In a heartbeat.
The siren said, “It’s the best feeling in the world.”
I kind of see where he’s coming from.