I went through the effort to sign up for all the loyalty programs and I travel some for work (or at least I did) - probably 6-12 weeks a year?
The loyalty programs were mostly negligible in value they provided. Some (like Amex Platinum rewards) were so hostile to get the value from it made me irritated to use it - not a direct hotel loyalty example, but a lot of them felt like this (calculated to give you the least value possible). Airline loyalty sucks and is a pain to use.
The CSV card was probably the only exception to this that I can think of.