SQL Clustering was designed mostly as a DR solution. There is something like active/active cluster but this is rather multi-instance DR cluster which allows you to have all cluster nodes...