Here are some videos that may be useful if you haven’t seen them.
Row limits are definitely a consideration depending on how much data you have. I personally have not worked with big tables. There are some minor limitations as far as using some computed columns with them. Also the fact that only small chunks of data are sent to the user device at any one time. Normal tables send all data to the user device immediately when they open the app. Also, if multiple users are updating data in a big table, it does not automatically sync to all other user devices. That new data needs to be refreshed by the user. This is unlike normal tables, which keep everything in sync on team time. But it all depends on what you need and how you will use that data. For the most part, they should work very similar to normal tables.