To be honest, I've never really had a good experience with SIP, but that's always seemed to have just been me in general, though I have seen several negative reviews still. From what I hear, they've been laggy over the past few months.
I don't care what people say about Frantech, it has definitely gone down hill in my opinion. They still advertise their out-dated Ragnarok services, and don't use the same stock for their original website anymore, but instead cheaper VPSs on a completely different website with less than average specs.
As for godaddy and Dreamhost, as yC mentioned, they're more known for their web hosting. Dreamhost's VPS, in the past, was laggy for me.
If you don't mind using overseas hosts, I would go with that, as most players now-a-days are either from Europe, the U.K. or elsewhere in the Eastern Hemisphere that isn't the U.S. The host I'm currently using is called BiBihost, which was recommended to me by the owner of our server. It's Italian based, but the dedicated server we use is located in France. In my experience, depending on where you're located in the U.S., they don't lag and overseas hosts are generally better anyways. I'm paying $149 p/m for 16 gigs and 10 TB bandwith.
As far as I can see, though, most people use generally non-RO supportive hosts, as most of the big names, as I said, such as Frantech and SIP have gone fairly decently down hill.