I've found that, for general education science courses at the community college level, the teacher makes the class. Find out which course has the most energetic, inspiring, or involved teacher at your college. The more easily your professor can relate to you and your peers (and vice versa), the more pleasant your class experience will be.
If you aren't willing or able to do that kind of research, and assuming that you're a non-science major, then I'd recommend, in order:
#1) ERSC 121 - Physical Geology. Every introductory geology course worth taking will have a mandatory field trip. It will be one of the most memorable experiences you'll take away from your time at your community college. It sounds super boring (yeah, let's go camping for a weekend near a bunch of rocks, fun...), but that'll only be a few hours out of each day. The rest of the time, you'll be bonding with your classmates, forming relationships that may last for years. I know students who met in an introductory geology course, became a couple over the winter break, and are now happily married. Sure, some of the lessons you'll learn in this course will stay with you (where does your water come from? what the heck is oil, and why is it so controversial? why do global oceanic temperatures even matter?), but I'd recommend this course as #1 for the field trip alone. There will probably be some memorization involved (you might be required to identify a collection of minerals/rock samples by physical examination), and there will probably be a little bit of chemistry (but no math, if your instructor treats it as a general education course). It won't be an easy class... but then again, none of these classes will.
#2) ENVS 101 - Introduction to Environmental Science. Of all of the courses listed above, this is the course that will have the most relevant lessons for you. You'll be able to apply what you learn to your own life and environment, and this course will be most likely to broaden your perspective of your surroundings. Depending on what topics you'll cover, you'll probably see some math and some chemistry. You might cover some biology and some general topics from geology. Consider this a broad mixture of the other courses (except Astronomy) combined into a single class.
#3) ASTM 101 - Astronomy. Of all of the general education science courses, this is the one that inspires the imagination of most non-science majors. When you finally come to a clear understanding of the lessons in this course, you'll be saying "MIND. BLOWN." over, and over... and over again. You're almost guaranteed to see some math when you're learning about orbital motion, so if math is your weak point, be sure to get help for that part. You may be asked to go on a short field trip for stargazing (you'll probably point a powerful telescope at Jupiter to see its four largest moons, and if you're really lucky, you'll get to look at Saturn and its rings). There will probably be a little bit of history involved (who was Galileo Galilei? Nicolas Copernicus? The Man with the Golden Nose? Johannes Kepler?), and you might learn a little bit about NASA's space program. Finally, your professor will probably be ready to answer all of your questions about Matt Damon living on Mars.
#4) ARSC 103 - Natural Science. This might be the easiest course (heavy emphasis on MIGHT). Unfortunately, it will probably also be the most boring. That's because in all likelihood, the instructor teaching the course won't be very passionate about the learning material. Take this course at your own risk, because I'll bet money that you'll forget that you ever took it.
#5) BIOL 100 - Exploring Biology. If this is anything like the college-level Intro to Biology course I took, it's going to be pretty tough. You'll probably learn about the cell, its constituent parts and how they work together, the energy cycle that powers all of life as we know it (lots of chemistry in this part), and of course, about DNA. My guess is that this class won't be about bears or birds or fish. It's going to be very technical, and you'll be learning about stuff that you can't really look at without a microscope. Expect a lot of memorization (what does mRNA do? what's a mitochondrion? what's the difference between a cell wall and a cell membrane? what does ATP stand for, and why is it important to the cell? what are the steps in the Krebs Cycle? what is an amino acid? etc). If you're up for the challenge, the lessons you'll learn here are very enlightening.
#6) CHEM 100 - Chemistry and its Role in Society. It's chemistry, and there's really no way around the fact that chemistry is kinda hard.
Remember that everything I've written here can be turned on its head by an awesome teacher. Geology is going to be a horrible experience if you have a teacher that you can't stand, while Chemistry could be amazing if your teacher is super engaging and funny.
Best of luck with your final semester, and congrats on making it this far! :)