Truth be told, I've never had a negative reaction anywhere in Asia, Europe or North America. At most a double check like others mentioned (you sure you want one bed?). And it never came off negatively.
In my travels in North America (a while ago, admittedly) the majority of hotel reception employees were positively mincing - and I don't mean that in a bad way. So we never got anything besides a sly smile, if that!
Once it's even led to some bizarre flirting (the receptionist - big hulk of a man - at the Four Seasons in Provence actually said "I love your personality"). And that was rude, because he knew I was with someone!