I can't think of any view restaurants in downtown San Jose. Mezcal is our current favorite in the area for fine Mexican / Oaxacan food in a fun atmosphere. The Thai food at House of Siam has been reliably good though it's been a while since we've gone. Agenda sounds promising with a new southern menu by Chef Gator, formerly of Dolly Marie's and Gator's up in San Mateo.
House of Siam
150 S 2nd St, San Jose, CA 95113
25 W San Fernando, San Jose, CA 95113
Agenda Restaurant Bar & Lounge
399 S 1st St, San Jose, CA 95113