Notion's tables are ironically too complex to use but not powerful enough to provide good functionality. It would have been better if they just had a a simple table like in Word.

It's like they tried to jam airtable into their product.

Their tables are more like databases. I am looking for a simple, static table that I can enter lots of information into.

I log every day in a week as a 7x4(or so) table, and each cell contains a lot of information. Notion's tables are just not cut out for it. I've messaged their support several times asking for this feature, since their product is otherwise perfect, but basic tables of this nature are simply not on their roadmap for the foreseeable future.

I tried Notion but honestly found it to be overly complex for what I had primarily done in Evernote. Am I must missing some key workflow concepts with it?

Seconded. Notion does have table, but perhaps their typing makes it a little clunky for you?