During our stay we stayed in the Bay Landing Hotel with a bay view room. (Even numbered room on the second floor.). The room provided views and photo opportunities of all 28L and 28R movements as well as 1L and 1R departures.
Movements at Oakland
were visible in good weather but are extremely far so I didn't bother.
Any hotel along the
Bayshore Highway should provide a good view of movements at SFO if the room has
a view of the bay.
https://maps.app.goo.gl/C1dEuzVnZgnes5TE9
Credit Adam Feasey