Best all round is a Jamone. I did loads of research before replacing mine and its absolutely amazing. You dont even have to use a foot! I would go to a good dealer and talk about your requirements. I would think £150. Mine cost £250 and it is adequate for basic sewing with a good selection of fancy stitches. This has automatic tension and you can sew with any fabric. The buttonholer is brill but dont really use it.
There is a fantastic dealer near me who also run sewing courses, sell all the accessories and have great knowledge. Even though because of the boys and dog running amoke dont really get to use it that oftern.
The new John Lewis basic one (£50) is just fine for simple household sewing - i.e hemming, curtains etc. Comes in some very funky colours. Downside is no light by the needed (annoying when threading) and a short electric cable. Only had mine 6 months so can't comment on durability.