I love how you have broken down the blog types.
Using the Excel blog as an example, thats the searchable type content that steem needs, simply because people actually search for it. Traffic grows over time. On traditional media, Entertainment is more sharable/viral type content and traffic dies over time.
Expectations are an important factor in all of this. I think the personal blogs are doing well because the steem community have had a hard time, but we have stuck at it and we have moved beyond content creators to a close community.