With the increasing online exposure of urban public spaces, the new concept of “internet-famous sites” has emerged in China. Social media users are the main contributors to this new phenomenon. To fully understand social media users’ preferences in such kinds of public spaces, this article took 27 typical riverfront internet-famous sites (RIFSs) in Changsha City (China) as an example. Through social media platform selection, keyword research, text and image data extraction, visual and emotional symbol coding, and manual calculations of coding frequency, this study investigated social media users’ perception of RIFSs, especially on visual and emotional preferences. The online images and review comments were extracted from the popular Chinese social media platform “Xiaohongshu”. We found that (1) the popularity of each RIFS had a significant head effect and there were far more positive emotions than neutral and negative emotions in review comments. (2) RIFSs in Changsha were divided into five categories: commercial RIFSs, art exhibition RIFSs, historical and cultural RIFSs, ecological recreational RIFSs, and uncultivated RIFSs. Social media users had different visual focuses on each kind of RIFS. (3) Social media users provided specific reasons for their emotional preferences towards different types of RIFSs. This study can provide a new perspective on improving waterfront vitality and offer a targeted and attractive method for waterfront regeneration that is different from traditional methods.