Any of the Propinball series are drop dead beautiful and fun to play.
The Web - a little long of tooth but still fun to play
Timeshock - absolutely stunning to look at and great game play
Big Race - Very nice looking and fun (a little complicated for my tastes)
Fantastic Journey - Stunning graphics but my least favorite of the series
Microsoft Pinball Arcade does a nice job recreating actual tables.
Here's my favorite site dedicated to PC pinball:
They rate a bunch of games.