I think autos got a bad rap in the begining, but now I can't notice a diference between photo and auto strains as far as taste, potency, etc. As far as your questions - well, it all depends on your growing skills. The genetics are out there, so you have the ability to grow better than anything you bought on the street. You can easily dwarf the best bud you have ever smoked by growing your own - even most autos! I would recommend doing some searching and find some strains that have been worked over real well. There are new super autos out, as well as auto hazes - they look like they get pretty big and should be large yielders. If you want good yields in an auto - check out the super autos by Stitch - specifically Chaze. They do take longer to grow, but but if thats what you are looking for, try it out. Also - have you seen the e-store here? Mossy has some strains, but also LBH who has the Hazes. I've never grown any them, but I'm sure we will start to see some reviews pop up here ina month or two.
But back to your yield question. My needs are different - I like small plants with quick turnaround. Each plant gives just over an ounce in 2 months. Grow 6 perpetual and you get 3 oz/ a month. I mainly make edables and concentrates and am not a heavy user, also I grow solely for my own personal use - so your needs might be different. Large yielders take longer to grow and get taller/take up more space. They also get lanky/stretchy and need to be tied down or LST'd. If you do some quick math, a plant that yields 4 or more ounces is great, but it takes almost twice as long to grow, and takes up a lot more space. If you run into some growing problems (nute issues/burn, pests, heat problems, etc.- or god forbid rippers outdoors) you just lost a lot of time and effort if your ladies get stunded or worse....die. With small autos, there is not as much risk, or it is easier to mitigate.
I grow outside and have two 3'x2' beds used for cultivation. I run 6 autos in one area and 1 photo in the other. The low yielding autos give an annual harvest of just over 3 lbs. The other large yielding photo gives just over 1 lb per year (if I'm lucky) and I have to wait all year for it. Albiet I'm outdoor and you are most likely indoor. But you can see by the math that the lower yield plants work better for me. Fresh herb all year round as well!
Take some time to figure out yield vs time to grow as well as space requirements. Calculate it out and see what works best for you. My recommendation is to find your great yielding strain and grow it, but don't hesitate to run some smaller strains with quicker turnaround and experiment. You might just start to become a connoisseur without even knowing it. Let us know what you go with, as I'm sure others have the same question as you. And remember - theres nothing wrong with wanting a high yield strain. I just wanted to show another side of the story. Welcome to the wonderful world of growing. You may experience some problems as you get started but don't get frustrated - we all went through it. Just keep asking questions here and there are always people willing to help out.