ENT is the show that taught me a very valuable lesson: simply because it's Trek doesn't mean I have to like it or bring myself to watch it, if a TV show is weak then its ok not to like it and move on.
ENTERPRISE was my very first chance as a kid to watch a Trek show from start to finish on its first run. I was born in 1987, so obviously I couldn't watch TNG until later. My first exposure to Trek was through the first six films when I was 7 years old, renting them on VHS. I was instantly a fan, but by that time TNG was already in the middle of its final season and DS9 was in its second. I suppose I could have tried watching VOYAGER when it premiered (I actually remember seeing the premiere), but I was too young to try to catch up, and gravitated more toward shows on Nickelodeon.
I was eager to watch ENTERPRISE. However, TNG had started reruns on Spike TV (known as TNN at the time), and its timeslot was 8pm, the same as ENT aired. So I would watch TNG every day of the week except Wednesdays so I could watch a new episode of ENT. I thought the new show was okay, but I was finding myself far more into TNG. After 8 or 9 episodes of ENT, I felt more inclined to watch TNG. I never looked back.
Months after cancellation, ENT started to get syndicated reruns. Funnily, they kicked off those reruns with the fourth season episode "Borderland". I had heard really good things about the fourth season but never really watched it when it aired. After the Vulcan trilogy wrapped, I was shocked by how good the fourth season was. Suddenly I want to watch more of this show!
Back in 2009 I decided to Netflix the entire show through mail so I could watch it from start to finish for the first time. Rewatching the first season, I realized why I ultimately gave up on it: It's dull. The first season of TNG isn't any better, but it's at least more vibrant, colorful, and is swinging for the fences, whereas the first season of ENT just felt like it was going through the motions. It was tired.
Safe to say, what ENT needed more than anything was an injection of new blood. Berman and Braga had been doing Trek for too long and needed to hand it off to other people. Season 3 and 4 were proof of that.