In my opinion, the ideal apprenticeship would be one where you could learn a lot, while still having enough time for your normal studies. An apprenticeship is where you are taught a certain trade by a much more experienced person. Most of the time, there is next to no pay, but what you don’t get in money, you gain with experience.
Two other programs much like the apprenticeship are the Internship and Co-op Programs. Both are organized by multiple universities and require interviews to get accepted by other companies. Internship programs are only organized during summer breaks, but Co-op programs are split up during the school term. The main difference between these and the apprenticeship is that for the Internship and the Co-op programs you have to be in University.
I think that the ideal apprenticeship depends on what you are planning to do. If you decide that you want to start a business, take an apprenticeship at a successful small business. If you decide you want to feel out what a work environment is like, then take an Internship or Co-op program at a bigger company. Overall, I think that it just depends on what you want to do. I would like to work at a bigger business, so my goal is to get into Google.