The Blarney Stone ought to be pretty insane on St. Patrick's day.
Best view? Get a room at a downtown hotel with a north facing view. Then wake up early on a sunny morning and open the curtains. If that doesn't impress the hell out of you, nothing will.
Quick input RE: "awesome views": if the OP is on a budget, he/she may be in better shape getting a hotel around W. Broadway, near VGH. Like the Holiday Inn @ Broadway/Heather for example. There's a view of downtown AND mountains. (check this e.g. that looks very likely it was taken from this hotel). Maybe the Park Inn too. Neither of these places are super fancy, but they do offer at least some rooms with great views, there's a Skytrain Station only a couple blocks East, and I'm guessing they'll be cheaper than many downtown hotels.
Agreed on Blarney Stone for St. Patrick's. Agreed on Grouse being a top choice if there are no clouds.
@OP: are you a runner by chance? One of the best ways to get a feel for Vancouver is a run along the seawall. If you're being budget conscious that one will cost you nada (walking is also a fine option - you just cover less ground ).
Don't know if you're a Canucks fan (or - looking at the schedule for the nights you're here - an Avalanche, Yotes, or Wild fan), but if you want to watch a game in a crowd, you could hit up the Kingston or Dix (many other posters here can point you to good spots).
Always a treat to have people come here who are excited to check the city out. Hope you have a great time.
Consider taking the Seabus across the harbour (It costs about $3.00 these days, I believe). You'll get great views there and back. On the north side, there's lots of good casual food options at Lonsdale Quay. (Think of the boat trip as Vancouver's version of the Staten Island Ferry, one of NYC's great tourist bargains.)