Great question, Sumer! I'm sorry to hear that you weren't taught science properly. Real science is very exciting. It's a process of exploration and discovery!
One way that the fun is sucked out of science is by (incorrectly) teaching a five- or seven-step "scientific method," which makes science seem much more cookbook and uncreative compared to the very creative and exciting process that it is. In short, that "scientific method" stifles creativity, it’s not like what most scientists do, and it omits important aspects of science, including careful observation, collaboration, finding out what's already known, creating models, and arguing from evidence.
Science is a process for learning. Show students some interesting phenomenon, and have them discuss and investigate what's going on. This is the basis of Phenomenon-Based Learning, where students are motivated to learn through their own curiosity. See:
And definitely look at Berkley's Understanding Science website. It is excellent.
There are teacher resources for all grade levels.