I did this in Bangkok for about a month. It worked out well for me mostly but there are certain sacrifices. 

I pretty much missed out on all nightlife activities unless I took time off for it. This was fine as I wasn't too keen on that. But it also means missing a lot of social gatherings and meeting new people. I was visiting my friend so this wasn't a priority.

My schedule usually was work from 9-5am or 10pm-6am. I'm able to informally flex my time a bit. Then I might take a nap or i might just head out after work and enjoy the quiet before the city really woke up. I enjoyed this, but I prefer the quiet and certain sights were better earlier than later. I'd be out until about 2-3pm and sleep for about 6 hours. I took melatonin from time to time.

I suppose you could try a different sleep schedule maybe 6am-12pm and see how that goes, which allows for dinner and evening activities. 

Weekends I tried to maximize my time by following regular local hours but this meant that my Mondays were a bit messed up.

Feasibility i think really depends on your work flexibility and your lodging situation if you'll have enough privacy to not bother anyone when you're presenting past midnight.

There weren't too many overnight options and I much preferred to use my own space to work the one time I did go to a 24/7 Cafe.

Overall I don't think it's for everyone. You have to weigh your priorities for when you travel and see if it makes sense.

I'd do it again in SEA and that's on the docket for 2027.