Not really. Early in the game you're better off spending the money on extra infantry. However, mid and late game the flanking bonus you get can cause stack wipes to occur when you wouldn't get them without cav present, so a small investment when you're stupid wealthy is worth it.