Light vs Electron Microscopes
Light microscopes are the ones you'll actually use in school, and they're brilliant for getting started. They can magnify up to about 400x in most schools (though some can go up to 2000x), they're relatively cheap, and you can observe living specimens without any fuss.
Electron microscopes are the superstars of the microscopy world - they can magnify up to an incredible 1,000,000x and show much finer detail. However, they're extremely expensive, need specialist training, and anything you want to look at has to be dead and placed in a vacuum.
Resolution is just as important as magnification - it's your ability to distinguish between two separate points in an image. Think of it like pixels on your phone screen: more pixels means sharper, clearer images.
Remember: Higher magnification doesn't always mean better - you need good resolution too!