Our experience is vastly different!
While not a fan of dragon fruit, I do eat it relatively often as my wife loves it. We usually buy pre-peeled pack at the super market when we visit.
For me it is definitely sweet. Not 'extremely' but it's definitely sweeter than a good banana or royal grape. Definitely not bland at all. I don't think I've had a non-sweet version in any of the countries you listed.
Edit: I just had a thought. I always eat Purple dragon fruit, not the white one. Maybe that's the difference.
Anyway, I'll keep trying dragon fruit hoping for a sweet one.
I think at the moment my favorite fruit I've had in SE Asia is cherimoya and I'm surprised they are not way more popular as they are so dang delicious! It's like someone made an apple + orange creamsicle fruit
It's one of my wifes favourite fruits, but we can't find good one in Singapore.
To choose a dragonfruit, pick the ones where the "leaves"/"tips" aren't dried out, feel heavy/full and slightly firm.
Keep in mind that there are over 200 varieties of Durian - some are even red inside, some sweet, some more pungent than others, different notes and textures. The best for me is Musang King variety in Malaysia, esp. when they get a slight alcohol after taste.
There are different places you can get durian puffs where the filling is basically pure durian. Of course, unless you love durian you're not going to appreciate them.
As for the seeds I agree. It's like eating kiwi seeds.
Mangosteen is great! No idea why the author had so much hate.
Durian though ... well I've tried it about 7-8 times and I get that it "tastes" good but I still don't get it. For example in Singapore there is a chain of cream puff stores that carry durian and vanilla cream puffs. To my "unrefined" palette they taste 95% the same but one stinks so if I was to go again I'd choose the vanilla that doesn't stink vs the durian that does. I'm sure I'll try them again but I suspect my reaction will be the same. Tastes fine (like vanilla custard) but why put up with the stink when I can just have vanilla custard.
That said, last summer when I was in Malaysia was the first time the smell started not being so repelling so (a) I'm getting used to it (b) they were in season (c) like the cat virus they've reprogramed my brain :P