The calvary usage in the Civil War was an interesting moment in time. Soon thereafter, they were marginalized due to better rifles and artillery and by the time of WWI they were mounted dragoons at best.
Interestingly though cavalry troops continued to be used through all of WW2.
Always find it interesting there was no heavy cavalry wearing breast plates as one saw in Europe. American cavalry was hardly employed for shock action.