> Dubai to SFO is also a possible route

Is there really that much premium traffic between Dubai and the Bay Area?

My point is mostly that since the 80s there's a lot more trans-pacific flight from the Middle-east and Far-east to the United States. When the Concorde was developed this wasn't really a worthwhile market to consider for ultra-premium air travel.

I could absolutely see Emirates doing a super-luxury super-sonic flight to the West Coast of the US. Once you're in the States you can take a PJ.

The Middle East (was) a pretty common stopover for India flights, since India's not that well connected to the US due to a lack of capacity.

A couple of searches suggests only Emirates operate a direct route between SFO and Dubain, so it wouldn't seem so.

Emirates just dominates long-haul flights to Dubai overall. Other (mostly flag carrier) airlines handle other airports in the region. Qatar Airways through Doha is also a big player in flights between the US/Europe and Asia.

I think the more interesting question is /will/ there be that much premium traffic ongoing

Honestly not so much in my experience. It was busy, but mostly because of Emirates longhauls. Dubai to NYC and back is extremely busy though.