Jordan:
This is a math problem at its heart, which I'll solve for you below.
Let's say the length of your hole is 200 yards, or 600 feet. The green can't have more than a 3% tilt if it's going to work at high green speeds, and I suspect you want to see some of the green surface from the tee.
So, take that same 3% tilt and extend it back 600 feet. That's 18 feet. Add in the fact that your eye level is five feet above the tee, and now you're at 23 feet. That's the limit for seeing any of the green from the tee, other than a false front or a severe tier in the green.
I think if you look at a lot of the hole Gerry B mentioned, you'll find they climb 15-20 feet so you can see the green a bit better than that. The 11th hole at Crystal Downs is 17 feet uphill and the green tilts at 4% with some bigger tiers, so you can see it really well, but the tilt is becoming unplayable when the greens are at 10 everyday.
If you look at a lot of the famous courses, that same 20-foot step was often used for uphill tee shots as well ... but you can get away with a lot more on the tee shot if you want, because the landing area can tilt a lot more than 3%.