If you do have an American passport, you get a double-whammy in opportunity costs: you can already work in SV, and you still have to pay American taxes even when you are not working there.
---
The government housing in Singapore can be quite nice. But yes, you are going to live in a high rise tower, most likely. Not a country house.
Some people prefer urban living and short commutes.
One effect that I only appreciate after living in Singapore for a while and then visiting elsewhere: the peace of mind not having to look after all you stuff when you are out and about. In Berlin or London or New York, I need to constantly worry that someone would nick my laptop, if I leave it on the table in a cafe when going to the loo.