Very interesting comments here, thanks. I am 200 lbs. Dropping, yes, but no way will I drop below 190 regardless. I do most of my riding on city streets on a road bike. I am not too concerned about shaving off grams or seconds.
I never really thought about a weight limit though. Funny the guy at the lbs didn't mention that when showing me the Specialized. Perhaps I will be better off looking more at going to 105 or Ultegra rather than the frame itself. It seems to me that most of the big names are pretty similar in comparison at this level.