I thought it was great when I first saw it but it hasn't aged very well for me.
I don't hate it, though. More of a "meh", now.
It does have some redeeming features. Like others have noted, the soundtrack and Gary Sinise are both awesome.
And for some reason, the whole "Bubba explains all the different ways to prepare shrimp" thing that takes place over the course of several rapidly cut scenes still cracks me up.