This is incorrect for the same reason as the last query. MAX() returns the highest value for a given column (attribute). It has nothing to do with frequency or counts. The following would work:

SELECT users.name FROM users INNER JOIN statuses ON users.id = statuses.user_id GROUP BY statuses.user_id ORDER BY COUNT(statuses.user_id) DESC LIMIT 1;