The redsnapper is a very good tripod. I have had both this and a frotto 190
THe redsnapper is higher than the manfrotto by a reasonable amount - and I found it much more stable due to the extra height/spread on the legs.
The manfrotto has flick lock legs wheras the redsnapper is twist lock. This just means that the manfrotto is quicker to put up and drop down.
The Manfrotto has the horixontal centre column wheras the redsnapper comes with a second short column that allows for really low angle shots (If you get the redsnapper Joe can supply column parts so youy can have two complete column assemblies at a very reasonable price)
Overall, I would choose the redsnapper unless you want a tripod that goes up and down quickly. That is the only thing the frotto has over redsnapper that is of real world use IMO.
With regard to heads - the redsnapper ballhead gets very good reviews, although the manfrotto 486 or 488 are also really good. All will take a 40D with ease