Although specialized trials bikes are very bizarre (hydraulic rim brakes, rims roughened with an angle grinder, the freewheel at the bottom bracket) people with enough skill can do a lot of tricks on much more normal bikes. So I think a compromise is possible. The main requirement is just that it be extremely strong.