My in-wall tank sits on a custom 38" stand. My tank is 28" tall (150), so in order to reach the bottom of the tank, I need to stand on milk crates. But then again, I have access to the back of the tank from the back side. So the ugly milk crates work well.
As for the view from the front, it is great while standing (the top of the glass is almost eye level (5'6" +/-), so you don't have top squat. But while sitting on the couches, I think, it is a bit high, maybe 2 or 3" lower would have been ideal if I were to do it again.