This is a tough question to answer due to the variety of people, their experiences, and their world view. The kind of people that like lake front are those people who have some positive experiences with water activities. I will try to list a few perspectives of people who might like waterfront, and then a few people who might not like waterfront. Use it as a starting point to determine if waterfront is for you and/or your family. Also, consider if the person you invite up to your lake front is a match.
People who might like waterfront are:

…People who have had positives experiences with water activity

…People who are “outdoors” people.
… who like camping
…like exploring
…like living close to nature
…like water sports
…like the feeling of getting away from the “hustle and bustle” of a busy life
…like to maintain property
…like to rough it
…like fishing and swimming
…like the sun in their face
…like a campfire
…like board games on a rainy day
…are willing to share with bugs, birds, bees and animals.
…can tolerate some inconveniences
…can live without TV, Internet, texting, and many other instantaneous devices.
…can live without a mall nearby
…are willing to give up some home community activities to go to the lake on weekends
People who might NOT like waterfront (mostly you can’t change people):
…People who have had traumatic experiences in the water.
…People who are happy staying inside and watching TV
…who dislike camping
…solitary sedentary type of people.
…who have never lived near nature and may be fearful of it
…who need the busy life and feel empty when they don’t have it
…who do not like yard work or property maintenance

…who need all the conveniences such as dishwasher, washing machine and public water supply

…like swimming in a pool with chlorine as they do not like plants and fish.
…worried about the effects of the sun such as cancer (even with sunscreen)
…that are afraid they will get diseases from the outdoors
…hate bugs
…hate inconveniences
…cannot imagine life without instantaneous media or communications.
…have to have everything right now, live close to malls and stores so they don’t have to wait.
…Have community commitments that will not allow you to get away on the weekends
…often run their lives around their kid’s neighborhood activities (birthday parties, sports, etc.)