Yeah, all of us "veterans" also had to learn the game at some point, as well. It's not insurmountable (honestly, it's been awhile but I don't remember having that much trouble wrapping my head around the basics - but it was also far from the first RPG or turn-based game I'd played, so I'm likely a bit biased on that end.)
Both Fallout 1 and 2 also come with a selection of pre-made characters to choose from, which are sort of guaranteed to be viable for any beginning player (and are even useful as a starting point on creating a character from scratch.) That's what they're there for.
That said - I don't think it's really all that possible to "gimp" a character in Fallout 1 and 2. All stats are actually fairly close to equivalent in usefulness - a 40-point character will remain a 40-point character regardless of where you put those points. If you end up with a low Attribute, it's going to be because you have more points somewhere else. It ought to kind of balance out. Every stat (and literally every single item in your character sheet) has a full in-game description that can be brought up to read, so you're not going to be left in the dark as to what does what.
You really shouldn't be able to make a character that isn't capable of getting through the game (I've never been able to make one that couldn't at least.) You might have to adjust your playstyle to the character you've made (no wading through masses of enemies at the start of the game if you've spent all your points on INT and Science, Repair, etc,) but I'd think that's sort of a given in an RPG. You can't expect to start the game being able to kill everything you run into - it's a dangerous world out there, and you're not going to be able to take on every single random encounter you run into.
This is the sort of game where you're well-advised to fully read the manual before starting out, as well. (It's my understanding even the downloadable copies have access to a manual somewhere.) There is a bit of a steeper learning curve (these games were made before the in-game tutorial was a common practice - something that these games could have admittedly benefited from, as well.)
Hey, this game isn't for everyone. I think they're very good games. But I also don't recommend it to all of my friends, either.