I have a Pfaff Select 4
@annieeg , which has 40 stitches, IDT and needle threader (which does work well even for me) but few needle positions. It's a nice machine and good with some fussy fabrics, but it doesn't have any great space under the foot and while it does sew really well I am pleased to get back to its big brother. Whether the older ones are similar, no idea and some are asking silly prices.
As for electronic one, the older they get the more chance of problems, but even so some are asking silly prices for machines older than my Expression 2. I'm sure you could probably find an older machine which would last as long as you wanted it but I would be spitting feathers if I had to spend on money it before I considered I had my money's worth.
I suppose a lot depends on your budget for this.