I've been using a Singer Tradition 2282, bought from Lidl for £80, for the last 2 years which has covered everything I've done. I've made around 30 skirts/kilts ranging from traditional style tweed kilts using 16oz cloth to a button through cord skirt and 6 panel moleskin midi. It's also handled everything from turning up the hems on denim jeans and sewing together 12' x 9' heavy cotton dust sheets down to stitching narrow hems on anti static lining material. The last being hideously harder than the first two.
The only thing I haven't tried is leather. I prefer to hand stitch straps on kilts.
There are 3 main stitches I use; the straight stitch. the overcasting stitch and the blind hem stitch plus button hole stitch when I have to. These stitches should be available on any reasonable quality machine. I also use a range hand stitches on my kilts and, to a lesser extent, on skirts.
You do need to bear in mind a sewing machine is just a tool. Just as buying a jigsaw won't make you an expert carpenter, buying a sewing machine just allows you to stitch cloth, you still need to learn and practice.
When I got the sewing machine my partner gave me a brief 5 minute introduction (imagine teaching your wife/partner to use a power saw and you get the idea) and then I used Youtube. Buying a machine is also only the start of the cost, good quality cloth is seriously expensive, but there's no point in spending time making a skirt with cheap materials, and you also need a range of other items. Over the two years I've bought copious quantities of thread, several sewing machine feet, zips, buttons, buckles, hooks and eyes, leather strapping (including a leather punch so I could make straps), lining (cotton and anti static), canvas and interfacing, scissors, chalk, tape measure, needles, pins and numerous other bits and pieces plus spent the best part of £40 on the definitive "How to make a kilt" book, so the cost of the sewing machine quickly pales into insignificance.
Having said all that the satisfaction of making your own things is enormous and well worth the effort.