I am currently starting my junior year, but I have always been attentive about my education, especially college, I would say I am an above average student  4.1 GPA, I am looking for tips of people who have already gone through the process (or have any knowledge they would like to share). Tips for finding the right college, websites that help you find colleges for majors or a certain field of education? (Psychology, Medicine, Engineering etc.). College applications how was your college application, the to do's and not to do's? Community Service (Is it really required? For applications and scholarships??), sites for scholarships or tips for finding scholarships (this one is a main question) . How are sports in college? Last question just for funsies, how was your first day of college/university, (if you are currently assisting college how is it? Majors or undecided, share your experience, clubs, any reccomendations or must do's when one enters college. 

Well, when deciding what college you want to attend, first you should determine how far away you want to travel. Do you want to go to a state school? Furthermore, do you only want to attend a public state school, or are you willing to pay for and attend a private school? Public state universities would be your cheapest bet. Since you've got questions about scholarships, I'm guessing tuition cost is a factor. 

So after you decide what type of school/where you want to attend, you could start looking more closely at the majors offered at each school's website, see how the curriculum sounds to you, and if it sounds like somewhere you'd want to go. There's always the option of touring schools, especially if their within the state/driving distance.

Now to answer some other questions: For my state, yes, a certain number of community service hours were required to receive state scholarships. Community service always looks nice for scholarships and can even help get you into certain schools, I believe. Extra curricular activities, service, good grades, all of these are deciding factors for college admittance.

For me, since college applications do cost to fill out, and only 2 state schools had the major I wanted, I just simply applied to those two schools. Like I've said, I don't think there's a cure-all search engine for colleges, you should decide what you need, what you want to study, and then research the schools individually from there. You may not want to hear this, but not too many friends from my high school class came to the college I chose. My first week was quite lonely and depressing. However, I quickly made friends with some people on my dorm floor and things were looking up since. If you have a shell, college will break it. The people make the experience. 

College is much more difficult than high school because no one hold your hand.  You have to start learning excellent decision making because many classes don't take roll.  You can decide to skip because you don't feel like or you don't do the reading because you want to do something else instead.  There are pitfalls with college because the liability is all in your hands and no one else.... cares.... to put it one way.

In high school, the teachers were trying to help you as an individual.  In college, they teach to a mass of people and they don't have time for single students more often than not.  Of course that's not always true and it's not the rule.

I recommend this:

1.  Decide what you want to try in your life as a career.  Start doing volunteer work or learning about trades that excite you.

2.  Figure out where you can go to learn about them and develop your skills.

3.  Do all the reading.

4.  Colleges and universities come in varieties and each will be different from the others.  It comes down to what you make of the experience.

I'm being generic but your question was extremely generic and tough to answer.  Those are all questions you'll discover have answers for just you when you start doing your research.  Start now, though.  Many people have college selected when they're juniors in high school.

Good luck.