Like others said, you need to prioritize what is most important to you.

You list two criteria: sit up in it, withstand horizontal rain. Does it need to withstand heavy wind? Usually horizontal rain means heavy wind.

I use a tarp and net tent for two. If I have heavy wind/rain, I can pitch it with one side on the ground. I can raise it as high as I want as well to sit up in. With that said, it probably isn't great in heavy wind, unless it is pitched really low, ie, can't sit up in it.

So, prioritize what is MOST important, and the right tent will present itself, despite it's drawbacks.