Ok, this is about as clear as I can explain it. Forget the sports pack, it does not do anything what you think it does.
If you order a package of 120+ or higher, you will receive your RSN. In your particular instance, it will be NESN, and CSNNE. Both those are carried in HD by Dish for games, but it is not guaranteed. However, speaking only about those two RSN's, most all major league games are carried in HD as part of the package, you will get them in HD if dish carries the game in HD. Virtually every Red Sox game and every Bruins game is in HD. Celtics I would say most but not all are in HD.
I have no clue if the Revolution games are carried in HD by Dish, but I would not bet on it.
Again, it is believed Dish will soon be carrying all games in HD if they are provided in HD by the channel itself. But at this time it can be hit and miss, but as mentioned, the Boston market seems to be mostly in HD as compared to some other markets.