Are waterfront homes as cool as they look?

For those who own a waterfront home, how are you liking it? Pros and cons? I’m checking some out in Sugarland and they look quite pretty!