Holodomor - intentionally starving 5m people to death was so humanizing.
Bit of a paradox of tolerance situation here. Communist regimes have been some of the most dehumanizing in existence. It’s perfectly reasonable to not support them.
Not necessarily a pain, you just have to model the data very differently in something like DynamoDB. Those views are secondary indexes.
Search, though, you’re right. You’d be running ElasticSearch along side it and the cost and complexity starts to go up. Or just abandon having a functional search entirely, like Reddit did…
I’d also suggest looking at ZFS. Works great on Linux and it’s super powerful.