There's things to do, they're just a short walk away and that's why no one stays. the problem is there arn't the cafes there that there should be or anything to keep normal people there.
I think last time i was in the area, i ate at the patio of Joe's American... not bad, but they need more of it. i don't care if it's another chain, but everytime i'm there... it's like, "HEY! this is nice... let's go somewhere else". what can you do really? walk down to the end of the wharf, check out Columbus park, then what? you walk over to the North End which is right there or over to Quincy Market if you're just exploring.
The problem is that they have the stuff to get you there, just nothing to KEEP you there. I don't want to stay the night at Rowe's Wharf if i live in the area, I'll go home... I don't want to go to the Aquarium again, i've been there 100 times. If i wanna eat (and don't feel like Joe's) I'll go over to the North End or Quincy market... both areas have a full array of price ranges, indoor/outdoor eating, and selection... but it's not AT the waterfront. that's the problem.