Yep, they are perfectly fine for the non power user. When I first got my PC I had a GF2 MX 400, and could do everything that I desired which was:
Play games at 1024x768 (some at 800x600)
with some PC games (older titles) I could enable AA without probs, emulators could run AA fine (most)
Games such as Q3 etc ran at insane speeds at high detail, and generally most PC games ran fine.
Now fast forward a bit, yes the MX line could be a little slow at max settings/hi-res/any level of AA on newer PC titles, but that doesn't automatically make them bad cards. The lack of pixel shaders is a bit of a shame but again it doesn't make them bad cards because of it.