We stayed at apartment block 333 River Street which was right on the Hudson, next to the 'W'. Luckily for us the company paid for it as the rent for a massive two bedroom apartment was about $3000 a month (2008)
However, Hoboken is a big place so I would imagine more sensible rentals further away from the river front. It's certainly worth considering.