Thankfully, Andrew was a rare dry and very fast moving storm system. I was in the national guard then and the scary part was after the storm. Most of which never came to public light.
Andrew flew across Florida (I think it was moving 20mph+, which is very fast for such a well defined storm). My family has friends with horses in the area, some farms were completely lost. It was a terrible storm, the wind with Andrew was too much for many to handle. The Homestead area was in ruins after it went through. It was amazing that only 23 people died in the storm.
Most of the recent tropical activity (past several years) has been flooding more than wind. Isabel was a biggy last year (category 5 before landfall), but mostly noteable for flooding once it came ashore. Storm surge is always a big killer with big storms, and especially in low lying regions. If New Orleans was hit by a CAT 3+ storm correctly, much of the city would end up underwater.
A few interesting pages about some biggies:
Tis the season
Hurricane Andrew : Satellite Image
Hurricane Camille "The most extreme meteorological event to take place in North America"
Galvaston Hurricane "The Storm That Changed America"
*shrug* I hope word gets around far enough to discourage future looters. That will save your buds the necessity of going through it next time.