Garmin makes fairly solid devices (they have their flaws, but in general work well), however I feel you on their software. It's a nightmare, as any person who has used Garmin Training Center or Mapsource can tell you.

If you are really fedup with connect, try out our service at http://ridewithgps.com. We offer much of the same stuff they do and more.