The front window tables of Nine Dragons offer a great view of the fireworks, since the restaurant is slightly elevated. Your view is not blocked by everyone outside.
The old CS in Mexico did and I'm hoping the new Mexico waterfront resturant has good views because the concierge at atrium club at CR will be getting reservations here for our Thanksgiving trip. HOPEFULLY for Illuminations.
Definitely the new Hacienda de San Angel will be ideal, also can second Tokyo Dining and Rose and Crown. Word of warning, though, those great Illuminations views are highly prized. Many folks show up very early (up to two hours) and stretch their meals out to hold their tables. Be aware that even if you show up early for your reservation, tables with a great view are not guaranteed.