Lumeinshin
Yes I've played plenty of the Skyrim mods that make it so the start is randomized and the player can simply skip the opening sequence as well as the entire Main Quest if they don't feel like triggering the event set up by the mod
I think they still suffer from the game fundamentally being based around a Main Quest however, as all the rest of the content tends to be underdeveloped and underexplored compared to the MQ which gets all the attention, hence hiding away the big stuff and giving side content a bigger role to play (which players tend to use as roleplay anchors) plays into the extensibility of the game by giving the player greater choice
Also yeah the player being dragged into the role of the chosen one always plays out unnaturally and forced, surely there's a better way to set up an RPG/MMO protagonist
Fantasy
I can relate to this, not as strongly as some others who just never start the Main Quest past the point you're forced to do it, but I have experienced the main content the game pushes you into growing boring; and hiding away that part of the game is my answer to such boredom: just don't take part in the main content. Maybe the character you're roleplaying as just never finds the great crisis, maybe they refuse the call of adventure, the game shouldn't stop the player's development of their character just to insert something out of their control in the mix, have the player be a self-made hero throughout the whole game, not just the side content as it usually happens