A Bass 400 or 400+ is more then enough amp for a large venue (given you are using a big enough cab obviously). I have never had to turn my amp up past 3/4 (pre/master) using a sealed GK backline 4x10. Even then it was usually to loud.
As for destructability...I had the same worries until I started moving my 400+ around. The faceplate is like quarter inch steel...insanely beefy. The tubes shouldn't have to be changed much, though the amp will get some interesting tonal changes depending on what pre and power tubes are used (I have JJs in the power section, and they are supposedly the "smoothest", my pre's are all Mesa branded tubes). The preamp gives you some interesting options; changing out one of the 12ax7s (don't remember which one) increases clean headroom at the cost of gain - something that I really don't need, as it gets painfully loud without distorting in my experience. The cost of retubing I think is around $240, though really you shouldn't need to, especially if you mod the amp to have variable bias, which there is a thread somewhere around here with directions.
As someone pointed out, the differences between the two inputs are negligible at bedroom volumes, but become very apparent at gig volumes (and make for some sweet options!).
I also got mine for $895 about a year ago. You can still see them popping up for that price on a fairly regular basis.
Hope this helps!
-Loren