Philip Seamark shows how to visualize the relationships between tables using Power BI:
The network navigator was another good visual, and if you have an R instance installed on your local machine, you can play with some of the custom R visuals.
The catalog views could be used in a similar way to generate power bi visuals showing other object dependencies inside an MS SQL Database. Additional columns could be added to the base query to be used in tool-tips etc.
If your database tables do not have foreign keys, here is another query that can be used to help guess relationships between tables based on column name and datatype.
Most of these techniques look like they wouldn’t work well on databases with a very large number of tables, but for an average-sized database, it can serve as an avant-garde ERD.