My guess would be Embarcadero. It's in
THPS1 Streets
THPS4 San Francisco
Thrasher Skate and Destroy EMB
THPS1+2 IDK if it counts
Skate 1 there's an area near the X Games arena that's EMB
Skate 2 There's a Skate 1 DLC that includes the spot
Session San Francisco map
Skater XL free DLC San fran map
Brooklyn Banks would be high on the list, Carlsbad Gap too especially because School 2 has been in tons of tony hawk games, but it might get iffy for whats a grass gap and whats actually Carlsbad