FS1 scared me back when I was 11 years old... not anymore. I remember the first time playing through the campaign, I got depressed after loosing Clash of the Titans again and again. It was my first real video game, and I was really involved in the storyline... it made me really sad that the Lucifer kept blowing up Earth. As for FS2, I usually didn't feel very involved in the storyline, possibly because HLP ruined all the surprises. It did feel really cool before Their Finest Hour when Petrarch said, "this is our Alamo, pilots"; you get that FS1 feel of being surrounded and outmoded. But TFH was a crap mission, and it should have felt a lot more difficult and desperate. Volition had plenty of justification for turning that into a BoE mission with hordes of Shivan capships assaulting your outnumbered force, but they didn't take that chance. They instead beam-locked most of the friendly ships to create some sort of difficulty...
Yeah, BoE has a bad rap, but if you define it as 5+ capital ships, there are lots of good BoE missions. The only reason people throw mud at the idea is because of a few articles written by n00bs who didn't know how to use FRED. You can do it. It just takes a little more work than usual, and I wouldn't recommend it for "my fiirst misssion".