I too, am torn on the issue.
The thing is that I want to see some more large-scale attractions come to the city, but I want the city to go back to more of the feel it had before the big rides. What I really want the city to focus on is bringing out more heritage and craftsmanship. With this new coaster, I want it to really be part of the park. I want it to be push a classic SDC theme that is accentuated by a new plethora of surrounding shops, crafts, and andyisms. You might be thinking "well hell, that's what TGS was", but no, TGS is great in that it has some great andyisms and a strong theme, but it's pretty much a big ride with a bunch of stalls plopped around it. This time around, I hope to see some games that are actually relavent to the theme, some actual shops that sell more than t-shirts, and maybe some new craftsmen, also relavent to theme.
Again, it sounds bitchy, but TGS and GE have never really felt like they belong with the rest of SDC. I'm sure they will when the areas mature and characterize, but as it is they are kinda wacky. This time around I hope they dig up something really SDCish, that will really accentuate the atmosphere of the park as a whole.
As far as the coaster type itself, any of the above options besides the hyper coaster would be great, though I personally would prefer a solid Intamin Pre-fab woodie.