> What's the city like?

As far as I can tell, it's college-town-quiet. There are some shops in the downtown area, near the college, and there are some decent little places to walk or hike. Waterville has plenty of amenities, and while I could see someone exhausting the different things to do quickly, it's fairly centrally located to other locations you may find fun activities at.

> Are there areas I should avoid going/living?

Living, I'm not certain. Going? I wouldn't worry about where you go. Waterville seems tame.

What are the things you like? Knowing that may help folks point you in the right direction.